Format Statement in SQL

[Guest_imported]

Hi,

I want to format a column(avoid some leading zeros). Is there is format function in SQL query of SQL Server.

Urgent Help.

Thanks in advance

Sathya

 

[rac2]

I don't know of a format function. The closest thing is to use the string manipulation functions but it is ugly.
Suppose colWithLeadZeroes is the name of your column with leading zeros and that it is a CHAR or VARCHAR datatype.

SELECT SUBSTRING(colWithLeadZeroes, PATINDEX('%[^0]%', colWithLeadZeroes),DATALENGTH(colWithLeadZeroes))