a***e
发帖数: 188 | 1 In several records, there are "'"(single quote). I don't
know how to deal with it. In the query, I have to use single
quotes to embrace the strings. What should I do to let MS
Access think some "'"(single quote) are just like ordinary
strings?
Thank you very much.
|
s********e
发帖数: 62 | 2 try \' or /'
【在 a***e 的大作中提到】
: In several records, there are "'"(single quote). I don't
: know how to deal with it. In the query, I have to use single
: quotes to embrace the strings. What should I do to let MS
: Access think some "'"(single quote) are just like ordinary
: strings?
: Thank you very much.
:
|
a***e
发帖数: 188 | 3 Thank you very much. But I tried it already, it didn't
work.
Thank you again. Merry Christmas!
【在 s********e 的大作中提到】
: try \' or /'
|
p*****e
发帖数: 58 | 4
I don't know how SQL statements work on Access. But in MS
SQL or other dbms, you use '' (two single quotes) in SQL for
the single quote character. Just like in C you use \\ for
\.
Example:
Update table1 set description = 'That''s the big boss'
【在 a***e 的大作中提到】
: Thank you very much. But I tried it already, it didn't
: work.
: Thank you again. Merry Christmas!
|
g****e
发帖数: 299 | 5
In Access or VB, you can use function chr().
【在 a***e 的大作中提到】
: Thank you very much. But I tried it already, it didn't
: work.
: Thank you again. Merry Christmas!
|
