how to write a search query

I am using asp.net 2 with visual web developer express and mssql express database.

My question is how do i write a query

i am writing query in mysql the same query how do i write microsoft sql server

select * from emp where city like “ca*”;

For eg if would like to list cities which matches first two characters as “ca”

thanks