[AccessD] Search for string with wildcard characters

Mike and Doris Manning mikedorism at ntelos.net
Mon Apr 14 10:20:24 CDT 2003


How about InStr function?

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
rusty.hammond at cpiqpc.com
Sent: Monday, April 14, 2003 10:57 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Search for string with wildcard characters


Does anyone have any code that will search a string variable for a string
that includes wildcard characters and returns the location?

ie
strVariable="This is a test"
search strVariable for "te??" returns 11


Rusty

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list