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...