I am trying to write a script that returns a decimal value where the value in the column is only two characters. The values in the column I am returning are currenlty 4 character AND 2 characters. Example: 36 and 50.99.
I want it to change the 36 to 36.00 but I don't want it to do anything to the values that are already in a decimal format.
Any suggestions would be appreciated.
I'm new at SQL and got close with a convert but don't know how to do it without telling it a specific value.
I want it to change the 36 to 36.00 but I don't want it to do anything to the values that are already in a decimal format.
Any suggestions would be appreciated.
I'm new at SQL and got close with a convert but don't know how to do it without telling it a specific value.