Select records in field begining with an *

[DomFino]

Hi Everyone,
I am attaching to an old FoxPro database using ODBC. I need to select all the records in the lname field that begin with a *. I am having some trouble here since the * is default for wildcard in Access.

Can anyone tell me how to select all records in the lname field that begin with an *.

Any help will be greatly appreciated.
Thanks,
Dom

Here is a sample of the data in the lnmae field.

Eaton                    
Smith                    
Robinson                 
Beser                    
*AAI Corporation         
*Abacus Srv.& Sys. Grp.In
Moore                    
*Accounting & Tax Service
Boyle                    
*ADP, Inc. (Towson)      
*Advanced Computer Commun
*Advanced Data Services  
*Aeronautical Radio, Inc.

 

[DomFino]

Woops!
I found the answer on another post (thread701-1186290)
by PHV

Like '***'

 

[PHV]

Another way:
Like '[*]*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DomFino]

Thanks again PHV.
You are amazing.
Dom