[AccessD] Find String Containing Quotations

Not an answer to your question as you asked it, but when I 
have to do things like this I tend to use either code or 
set up my query like this:

SELECT StringTest1.TestString
FROM StringTest1
WHERE (((InStr([TestString],Chr$(34)))=True));

HTH,

Ron



On Wed, 23 Apr 2003 15:42:56 -0500
  "Terri Jarus" <jarus at amerinet-gpo.com> wrote:
>I want to use a query to locate the records where the 
>specified field
>has quotation marks in it - but I don't know how to do 
>that since you
>have to use quotations around the string.
>
>I tried Like "*"*" or Like "*'"'*", etc. but with no 
>luck.  I know I
>saw how to do this somewhere, but can't locate it.
>
>Any help??
>
>Thanks.
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

<TEXTAREA NAME="Signature" ROWS="4" COLS="60">