Thanks for getting back so promptly. I feel very rude not responding earlier.

Bad news for me though is that your suggestion didn't resolve the issue. I'll get back...

How do I say something equivalent to

.....

WHERE

ColumnA LIKE

CASE

WHEN @Type = 'TWO' THEN N'%' + ' 20-' + N'%'

WHEN @Type = 'THREE_FOUR' THEN N'%' +...

Thanks so much!

Thanks. Exactly what I needed!