Is there an equivalent of Fox's $ operator in SQL's query syntax? For example, in Fox I can ...

SELECT * FROM customer WHERE "AL" $ customer.lastname

... how I do the same in SQL Server?

Thanks.