how to do a wild card search with sqlserver

Is there syntax that lets you look for all names that include ell in them? That is, in Oracle it would be:

select id from customers where firstname like(%ell%)

Or, is there regular expression support in the select's where clause?

thanksTry:

select id from customers where firstname like '%ell%'