[AccessD] Find String Containing Quotations

Try these, and use the InStr function to determine if they exist in the
field.

    Const CHR_DOUBLE As String = """"
    Const CHR_SINGLE As String = "'"

Charlotte Foust

-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com] 
Sent: Wednesday, April 23, 2003 12:43 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Find String Containing Quotations


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