|
 |
access thread: find double quotes in table
Message #1 by "Z" <zzz8611@y...> on Thu, 15 Feb 2001 17:54:24
|
|
How do I find all entries that have double quotes in a field of a table
using Access 97 query?
Thanks.
Z
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 15 Feb 2001 10:38:04 -0800
|
|
Use the Like predicate like so:
SELECT MyField
FROM MyTable
WHERE MyField Like '*"*' ;
Note that this will not get you embedded single quotes...
HTH,
-Roy
Message #3 by "Z" <zzz8611@y...> on Thu, 15 Feb 2001 21:17:32
|
|
> Use the Like predicate like so:
>
> SELECT MyField
> FROM MyTable
> WHERE MyField Like '*"*' ;
>
> Note that this will not get you embedded single quotes...
>
> HTH,
>
> -Roy
Thanks, Roy. It did what I need! Thanks.
|
|
|
View Cart
