This may be a li'l overkill, but it searches all databases and handles multiple search values as well.
SET NOCOUNT ON
/* Declare Variables */
DECLARE @Database VARCHAR(100)
DECLARE @TextToFind VARCHAR(100)
DECLARE @Lit VARCHAR(1)
DECLARE @Select VARCHAR(5000)
SET @Lit =...