>>>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 )
Sorry Cetin, meant to post that to Tim rather than reply to you.
Len Speed