SQL statement to achieve following logic with minimum length 5
For example: 2.34 to be 2.340
0.158787 to be 0.158787 and .2 to be 0.200 and 5 to be 00005 2093 to be 02093 and 78934 to be 78934
Tried LPAD,LTRIM and REPLACE
2
-
Check this answer stackoverflow.com/questions/43412377/…Phil Cook– Phil Cook2022-11-04 17:26:54 +00:00Commented Nov 4, 2022 at 17:26
-
Does this answer your question? SQL Server Padding 0's with RIGHT Not WorkingPhil Cook– Phil Cook2022-11-04 17:27:11 +00:00Commented Nov 4, 2022 at 17:27
Add a comment
|