Hi Bret,

I am a bonehead :-)

You are correct. In that case, his query should be:

SELECT * FROM mytable WHERE masteraccount LIKE "1________4___"





>>how do use a wild card in a query.
>>
>>In Visual Foxpro, how do you do a query that includes, a Master Account field of all the 1-??-???-4??? which would give you only 1-00-345-4010 but not 1-00-435-5034.
>>
>>Thanks
>>
>>Kevin
>
>If it is an SQL select there are wildcards using the LIKE command % character matches anything the _ character matches one character at a time.
>
>The help file:
>
>You can use the percent sign (%) and underscore ( _ ) wildcards as part of cExpression. The percent sign represents any sequence of unknown characters in the string. An underscore represents a single unknown character in the string.
>
>
>
>Hope this helps