How to remove leading space from sql server field

Is it possible to remove the leading space from a sql server field?  I did a DTS into a table and it has put a space in front of the field.
An update script would be appreciated.
EugeneCAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
LTRIM(urField ) will remover the spaces from the beginning

UPDATE urTable
SET urColumn = RTRIM(LTRUIM(urColumn))
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
u can use RTRIM(urField)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.