truncating empty string

• SQLRep

  SSCrazy

  Points: 2052

  More actions

  February 6, 2007 at 1:53 pm

  #175064

  hi all, I want to know how can i truncate the empty string after the address.

   

  eg: column --> Address1

  '1223 main lane                           ' i want to truncate the string after the text over to '1223 main lane'

   

  advise please

  thanks

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  February 6, 2007 at 4:07 pm

  #688164

  select rtrim(Address1) as Address1 from .....

  ______________________________________________________________________

  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