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.