>>>>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.
depends on the quote identifiers property in sql server if you are using quote identifier in SQLserver then must be single quotes since double is user to encapsulate reserved words.