>>How do you do a select with a wild card on a VFP table?
>>
>>For example
>>select * from mytable where the second character=2
>>
>>
>>i.e. these match
>>_2
>>123289932
>>
>>these don't
>>143343
>>141414
>>
>>To avoid code modification I would prefer to use one of the operators.
>>= or $ or ==
>>
>>thanks
>
>select * from mytable where myfield like '_2%'
>
>also like() is VFP function that uses ?,* as wildcard chars.
>Cetin
Note that the parameter order is swapped for like() - ie the equivalent query is
select * from mytable where like( '?2*', myfield )
Len Speed