> How do I escape the ' after the second '2' in this query? Do you really want only one ' to appear ? (my chemistry is a little rusty): you can escape a single quote using a backslash:
s = lower('2,2\'-(Butane-1,4-diyl)dibenzimidazolium dichloride')
or alternatively, enclose the string in " " instead:
s = lower("2,2'-(Butane-1,4-diyl)dibenzimidazolium dichloride")
best regards,
Stefaan.
