>>>Hello to everybody,
>>>
>>>Can somebody tell me please what is the VFP equivalent operator "$" in SQL
>>>
>>>I want to do as follow:
>>>
>>>SELECT * FROM CLIENT WHERE 'CORP' $ NAME
>>>
>>>Thank in Advance ...
>>
>>
>>Try LIKE %Something%
>>
>>SELECT * FROM CLIENT WHERE NAME LIKE %CORP%
>There're quotes missing
>
SELECT * FROM CLIENT WHERE NAME LIKE '%CORP%'
Does it have to be single quotes?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)