Using LIKE within CASE in TSQL

Question

I would like to select the records that contain the content of the @selctDescription parameter but only when @selctDescription is not empty.

I have the following, which does not work:

(t.[description] LIKE 
  (
  CASE 
  WHEN @selctDescription = '' THEN t.[description] 
  ELSE ('%' @selctDescription '%') 
  END
  )
)

Can anyone point me in the right direction?

Answer 1

SELECT * 
FROM Table
WHERE 
  ((@selctDescription IS NULL OR @selctDescription = '') 
   OR
   (t.[description] LIKE '%' + @selctDescription +'%'))