Re: Searching a string

From: PC Data*** (nospam_at_nospam.spam)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 19:04:42 GMT

 Like "*" & "w_" & "*" will returns anything with a w and an underscore in
it. 

--
                                        PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"buzz" <buzz@discussions.microsoft.com> wrote in message
news:DD7293D9-E29F-4BEA-8D1E-CF2A743F6F29@microsoft.com...
> I'm trying to use a query to a search for values that begin with certain
> characters and the values with vary in the number of characters.  I was
using
> the Like statement and that isn't doing what I need it to.  When do a
query
> using Like "w_*", it returns anything with a w and an underscore in it;
not
> just values that begin with the w and underscore.  I was trying to look
for
> something else but maybe I just overlooked it.  Please help.
>
>