Viewing 2 posts - 31 through 33 (of 33 total)
Remi,
Just realized that I posted a nearly identical solution as yours
I'd also hate to to see what that case statement would turn into if they...
January 19, 2005 at 1:56 pm
#538175
Or you can eliminate the CASE altogether and do something like this
SELECT 'ST_GR' = RIGHT('0' + CONVERT(varchar(2),ST.GR),2)
January 19, 2005 at 12:56 pm
#538163