Replace Function

[sandylou]

I am trying to replace any occurrences of an appostrophe before i insert the values into a table.

 Replace([Title],''',Space(0))

Which gives me the following error: Unclosed quotation mark before the character string '

How do you use the replace function when you are trying to find an appostrophe?

 

[earthandfire]

When looking for an apostrophe you need to double it ie

Replace([Title],'[COLOR=red]''[/color]',Space(0))

 

[sandylou]

THANKS!!

Declare @string char(20)
Set @string = 'Children' + '''' + 's Aid'
Print @string
SET @STRING = Replace(@string,'''',Space(0))
Print @string

 

[earthandfire]

Pleasure.

By the way, you could also change SPACE(0) to just '' if you wanted.

 

[dev2005]

Try this buddy

Select Replace('AB''CDE', '''', 'zzz')
go

After execution we get

ABzzzCDE

9We are replacing the apostrophes with 'zzz'

 

[cmmrfrds]

Also, you could try enclosing in []

Replace([Title],'[']',Space(0))

 

[sandylou]

THANKS!

 

[JamesLean]

cmmrfrds, FYI, your syntax using square brackets is invalid.

--James

 

[cmmrfrds]

Thank you, JamesLean, I had my syntax mixed up with Access. Although, I did find that the char() function will work similar to Access - chr(39) in Access.


Replace([Title],char(39),Space(0))