Tuesday, 13 October 2009

Using a like % @parameter % clause in a stored procedure

I wasted a few minutes scratching my head over this simple one, so it's worth me noting it down:

whatever like '%' + @parameter + '%'

It's not what I first did...whatever like '%@parameter%'.

Doh!

No comments:

Post a Comment

Comments are moderated, so you'll have to wait a little bit before they appear!