Replace (--)

• river1

  SSC-Insane

  Points: 24309

  More actions

  January 24, 2012 at 12:59 pm

  #255353

  Hi,

  I need to do a replace of "--" per nothing.

  I have tried this:

  replace(string,'--','')

  Because the "--" it's a comment i can´t do this...

  How can i replace "--" per ''

  thank you

• Leo.Miller

  SSChampion

  Points: 13051

  More actions

  January 24, 2012 at 1:14 pm

  #1437921

  I've just tested this and it works.

  select replace('This -- is a sample --','--','')

  Returning: This is a sample

  Cheers

  Leo

  Leo
  Nothing in life is ever so complicated that with a little work it can't be made more complicated.

• Dave Brooking

  Ten Centuries

  Points: 1373

  More actions

  January 24, 2012 at 1:20 pm

  #1437927

  I just tried this on 2008 and the replace works as expected. The -- has been replaced with an empty string, the - is left asis. I don't have access to 2005 at the moment.

  with cte as

  (select '--' as col1

  union all

  select '-'

  )

  select REPLACE(col1,'--','') as repcol from cte

  ;

  Dave

• Lowell

  SSC Guru

  Points: 323518

  More actions

  January 24, 2012 at 1:45 pm

  #1437942

  i'm guess it's more complicated than the original post's simple REPLACE function

  ...for example if he's trying to replace stored procedure text, but there's code that does something like ISNULL(Category,'--');

  he cannot simply replace the -- because the comments after it break the proc.

  he'll need to do a smarter search, like searching for '--' instead of just --, or use regular expressions to get fancy.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!