Removing spaces in the middle of a string

• Paul McCurdy

  Ten Centuries

  Points: 1377

  More actions

  November 21, 2003 at 12:22 pm

  #160224

  How do you do it in SQL Analyzer?

  i.e. I have a string that could contain 'TWC123456' or 'TWC 123456' or even 'TWC1234567' (length of number portion is not constant). How can I parse it and/or remove space in middle?

  Thanks!

• cmore

  SSCrazy

  Points: 2452

  More actions

  November 21, 2003 at 12:36 pm

  #483207

  there's several of string manipulation functions in SQL online help. I'm no expert on them all but the replace function would work.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 21, 2003 at 12:37 pm

  #483208

  Yes, REPLACE(your_string, ' ', '') should work

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Paul McCurdy

  Ten Centuries

  Points: 1377

  More actions

  November 21, 2003 at 1:07 pm

  #483220

  Thanks guys! Works beautifully.