Home Forums SQL Server 7,2000 T-SQL right aligned data RE: right aligned data

  • December 3, 2002 at 1:22 am

    #442872

    You can't do it easily. Something like this will give the desired result.

    

    SELECT SPACE(15 - len(cast(OID AS varchar(15)))) + cast(OID as varchar(15))