Posted by Steve on 09/20/05 15:42

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uneus9dvFHA.612@TK2MSFTNGP10.phx.gbl...
>> e.g. SELECT @strsql = "SELECT * FROM tblTest WHERE Field1 Like 'blah''
>
> Why is this in a variable? Why don't you just execute
>
> SELECT * FROM tblTest WHERE Column1 = 'blah'
> or
> SELECT * FROM tblTest WHERE Column1 LIKE 'blah%'
>
> ?

That isn't my actual code and was just an example.

Thanks to all who have responded.

[Back to original message]