Syntax Problem With Mask Special Characters

I have the following t-sql syntax

problem is masking information after like as special characters.

I will search for all entries in column filedirectory which begins with \

DECLARE @cmd varchar(255)
SET @cmd = 'SELECT id,name,filedirectory FROM MR_ReqPro.RQDOCUMENTS WHERE FILEDIRECTORY LIKE  ' \%'  '
print @cmd

EXEC master.dbo.xp_sendmail @recipients = 'kalleOO7@web.de',
   @query = @cmd , @subject = 'Fehler', @message = 'Fehler :', @attach_results = 'TRUE', @width = 2000

Thx

Kalle

 

here is the solution

DECLARE @cmd varchar(255)
SET @cmd = 'SELECT id, name, filedirectory FROM MR_ReqPro.RQDOCUMENTS WHERE filedirectory LIKE ''\%'' '
print @cmd

seems to work :-)