Escape Characters

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

If you want to parse in single-quotes, use two of them in your string:

select * from employeedetails where edescription='employee name is ''john jackson'' and state is ''ca'''

Gopi Muluka SSCarpal Tunnel Points: 4594 More actions · Answer 2

try this

select * from employeedetails where edescription='employee name is ''john jackson'' and state is ''ca'''

Jo Pattyn SSC-Dedicated Points: 32348 More actions · Answer 3

add another ' for every '

select * from employeedetails

where edescription='employee name is ''john jackson'' and state is ''ca'''

Jol SSC-Addicted Points: 429 More actions · Answer 4

Thank-you Guys for the help...I appended every ' with another '....

That worked

Kindest Regards,

Joel

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

They are covered under quoted identifiers and delimiters in ANSI SQL 1992. Try the link below for details from Microsoft. Hope this helps.

Kind regards,
Gift Peddie