Assigning value to @cmd gets error - Incorrect syntax near '/'.

[programmher]

This works:

SELECT CData.value('(/fields/Genres)[1]', 'varchar(255)')FROM Categories WHERE ReqNum = 9281

This does not:

DECLARE @cmd varchar (1000)
SET @cmd = 'SELECT CData.value('(/fields/Genres)[1]', 'varchar(255)')FROM Categories WHERE ReqNum = 9281'

I get this error: Incorrect syntax near '/'.

How do I resolve this error?

[Rabbit]

You need to escape your quotes.