Home Forums SQL Server 2008 SQL Server 2008 - General Strip leading zeros of a field and add a zero to the back of a field. RE: Strip leading zeros of a field and add a zero to the back of a field.

  • February 20, 2013 at 4:55 pm

    #1589777

    Hi Again

    Further to this I have also tried the following

    UPDATE tablename

    SET column = Ltrim(column,'0');

    But i get this when I parse

    Msg 174, Level 15, State 1, Line 2

    The ltrim function requires 1 argument(s).

    Any ideas?