literal quotes within a string

mr relaxo

Well-known member
Joined
Jun 25, 2003
Messages
53
Location
Auckland
I have an sql statement as a string like this:

"Select sizeid, CONCAT (sizeid, " / ", description) as merge from sizes order by sizeid"

I cant figure out how to get the " / " part to be taken literally. Can someone help me out?

Thanks,

Kris.
 
surround them with quotes
Code:
"Select sizeid, CONCAT (sizeid, """ / """, description) as merge from sizes order by sizeid"
 
Back
Top