SQL : Search text within a variable

[ultim]

In my SQL, i have declared a variable @description. I have set some text to it. How do i search that variable for a word? I have tried the following code.

Declare @Description varchar(255)
SET @Description = 'pipe text'

if exists (@Description LIKE '%pipe%')
begin
	print @Description
end

 

[lokkers]

You don't need the EXISTS

if (@Description LIKE '%pipe%')
--conditional code here

 

[ultim]

Thank you lokkers.