Home Forums SQL Server 7,2000 T-SQL Problem with CAST RE: Problem with CAST

  • January 19, 2005 at 12:56 pm

    #538163

    Or you can eliminate the CASE altogether and do something like this

    SELECT 'ST_GR' = RIGHT('0' + CONVERT(varchar(2),ST.GR),2)