problem in query when comparing strings

[anonymous]

[Originally posted by bvsmohan]

hai

i m getting problem when comparing string fields with another string which contains quote[']
like "select * from table where field='value's'

please help me
thank u

[anonymous]

[Originally posted by m.posseth@work]


this should work

"select * from table where field=""value's"""

happy coding :-)

p.s.

if you want to enlarge this statementy use the & symbool an a space

like this
"select * from table where field=""value's""" & " order by bla bla "

oh and something else it would be nice to close your sql with ;

so a better ANSI SQL statement would be

"select * from table where field=""value's""" & ";"

ÿ