>I'm trying to find an efficient requivelant of Fox's $ operator for doing the same thing in SQL Server (TSQL)... like so...
>
>SELECT ID From MyTable WHERE "some text" $ MyTable.Notes
>
>So what is the equivalent of "$" in SQL Server?
>
>Thank you.

The LIKE clause should do that for you:

SELECT ID From MyTable WHERE MyTable.Notes LIKE '%sometext%'