>>Is there an SQL equivalent to the $ operator in VFP that does not use the CONTAINS function?
>>TIA
>
>CHARINDEX() or PATHINDEX(), they are more like AT() VFP function:
>
>SELECT CHARINDEX([Text to search for], Field/Expression where you search in) > 0
>
Thanks Borislav