How do I remove the decimal point in a string using a SQL statement?
Also, the result must result in a Char field with 7 spaces.
So 123.8 would be 1238xxx with x's being blank spaces in a fixed width file.
or D02.3 as D023xxx with x's being blank spaces always to the right of the string.
I am using SQL 2008.