>>>>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.
Alexandre Palma
Senior Application Architect