There is no direct way. You would have to build a string by checking for hard values in the search criteria. For example:
LOCAL i
cSearchFor=".T."
FOR i = 1 TO 12 && len(cSearchCrit)
nVal=VAL(SUBS(cSearchCrit,i,1))
IF INLIST(nVal,2,5,9) && Delimiters
LOOP
ENDIF
IF BETWEEN(nVal,0,9)
cSearchFor=cSearchFor+" AND SUBS(table.masteraccount,"+ALLT(STR(i))+;
",1)='"+SUBS(cSearchCrit,i,1)+"'"
ENDIF
ENDFOR
SELECT * FROM table WHERE &cSearchFor
>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
------------------------------------------------
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