>>>>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.
It's a good idea to use the single quotes as string delimiters. This way you'll get consistent results. The double quotes can be used as string delimiters only id QUOTED_IDENTIFIER is OFF on Sql Server.
--sb--