Help with apostrophe

[RicardoPereira]

How do i select from my database a data with the ' character ?

I have a string (Ricardo's Pereira) in my database that has apostrophes. How should be my select statement to select strings with apostrophes in the middle?

Using "select * from teste where name='Ricardo's Pereira' " i got an error.

Any tip ?

Thanks
Ricardo

 

[btgroup]

Use a double apostrophe.

select * from teste where name='Ricardo''s Pereira'

 

[SQLSister]

You might read about set quoted_identifier in Books online. There are implications for how you must then handle the use of literals in SQL statments, so it is best to read the explanation.

Questions about posting. See faq183-874