Use "Like" with wildcards, % and _

There are a couple other wildcards, but these are the ones I use the most.

%AL% is find anywhere in string, like $
_ is positional wildcard. Anything in the position represented by the _

Pf

>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.