TRIM Function in SQL?

• WooGor

  SSC Enthusiast

  Points: 115

  More actions

  October 11, 2002 at 8:52 am

  #158844

  With VBScript, I use TRIM to take out the speces in a string value, what should I use with SQL?

  For example,

  SELECT TRIM(City)

  FROM T_City

  WHERE (NOT (City IS NULL))

  WooGor

  
  WooGor

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  October 11, 2002 at 8:57 am

  #438360

  You have the ltrim to trim the left spaces and the rtrim to trim the right spaces. If you want to trim both you can nest them like this:

  select rtrim(ltrim(au_lname)) from authors

• Malabika

  Grasshopper

  Points: 13

  More actions

  April 20, 2006 at 1:03 am

  #633177

  i have one query.If i want to trim the spAces in between a string then how to do that.eg 'United States' i want to trim as  'UnitedStates' in SQL

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  April 20, 2006 at 2:13 am

  #633184

  REPLACE(Country, ' ', '')

  _____________
  Code for TallyGenerator