Tuesday, December 1, 2009

SQL Query: Removing leading zeroes from SQL Server field

The SQL Query for Removing leading zeroes from SQL Server field

The following SQL Query removes the leading zeroes from "Field" field

Select replace(ltrim(replace(Field1, '0', ' ')) , ' ', '0') FROM TestTable


 
at
Labels:

1 comment:

  1. SadhanaJuly 25, 2012 at 5:06 AM

    Hey pal, you saved my day :)
    Thanks a ton!!

    ReplyDelete

Subscribe to: Post Comments (Atom)