Find Extra Spaces

• Ant-Green

  SSC Guru

  Points: 113520

  More actions

  May 13, 2008 at 8:59 am

  #380462

  Hi People

  Do you know of anyway to remove leading "Spaces" from a VARCHAR field?

  These can be anything up to 5 characters in from the start of the field.

  Rather than do a manual time consuming updates of fileds, I would like to develop a sproc to do this for me.

  Any tips / ideas / sprocs you have would be appriciated.

  Thanks

  Ant

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  May 13, 2008 at 9:02 am

  #814563

  Lookup LTRIM in BOL.

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg