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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05