>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