TRIM function for 2000?

• Mark Green-451799

  SSC-Addicted

  Points: 490

  More actions

  December 3, 2007 at 5:21 am

  #181051

  How do I remove all leading and trailing white spaces in MS SQL Server 2000? I notice that there is a TRIM function for 2005. What do I use with 2000?

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  December 3, 2007 at 5:28 am

  #756418

  SELECT RTRIM( LTRIM( SomeColumn ) ) FROM SomeTable

  --Ramesh
  

  ---