Home Forums SQL Server 2008 T-SQL (SS2K8) Concatenate Fields, But Evenly Space RE: Concatenate Fields, But Evenly Space

  • October 23, 2013 at 10:54 am

    #1661038

    declare @s-2 varchar(20);

    set @s-2 = 'October 2013';

    select REPLACE(@s,' ', SPACE(20 - LEN(@s)))

    returns:

    October 2013