Monday 23 June 2008

SQL Wildcard Search

I'm always forgetting the syntax for wildcard queries in SQL Server 2005 so here's an example:

SELECT * FROM myTable WHERE (myColumn LIKE '%' + @str + '%')

No comments: