Need Help~SQL string within a SQL string problem

[leonwoo]

Hi
I am writing a stored procedure in Microsoft SQL server 2000 as shown below:

DECLARE @sql nvarchar(1000)
SET @sql = 'SELECT * FROM myTable WHERE name LIKE ' + '%[%]'
EXEC sp_executesql @sql


The SQL analyser gave me the error
" Invalid column name '%[%]' ". I think there is something to do with the string quote but i am not sure how to put another string quote within that line of statement. Please help.