>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.
>
Best would be to use the SQL LIKE clause, which uses % rather than * and _ rather than ?, or you can use the LIKE() function. Realize that neither is optimizable; the LIKE clause ports to backends cleanly.