Trimming leading 0 in varchar field

[tavie]

I am trying to create a stored procedure that will take an 18 character field that is padded with 0 (zero's) and remove them and update the field with the new value.. I have tried to use ltrim and rtrim to no avail... I know it can be done I just cannot find the right syntax...Thanx in advance...Tavie

 

[HobbyMan]

This was just ask yesterday. Here is the link:

thread183-193266

 

[tavie]

Thank you Hobbyman that was exactly what I was in need of

 

[tlbroadbent]

Here is a simpler solution.

Update TblName
Set ColName=ltrim(str(ColName))
Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm