Chaitanya

Chaitanya

  • NA
  • 58
  • 55.7k

How to remove leading zeroes from a field in a SQL statement

Jul 6 2011 5:47 AM
I am working on a SQL query that reads from a SQLServer database to produce an extract file. One of the requirements to remove the leading zeroes from a particular field, which is a simple VARCHAR(10) field. So, for example, if the field contains '00001A', the SELECT statement needs to return the data as '1A'.
 

Answers (4)