t-sql question

[unknown]

hello

how to write in t-sql a statement like:

where a like %@variable%

in other words, everything that contains @variable
(@variable is varchar)

thx

[[e-mail] [Team Sybase]]

hello

select @variable = '%' + @variable + '%'

select ... where a like @variable

Michael

[Carl Kayser]

hello
thx

where a like '%' || @variable || '%'