Usi LIKE

SQL Server: LIKE Condition
http://www.techonthenet.com/sql_server/like.php