Escape [] characters in an sql query

[jkmyoung]

Is there a particular way to escape the characters [ and ]?
Using MSSQL (SQL Query Analyzer).
eg, query like:

[code=sql]
Select *
From table1
where message like 'Finished File(s) [\\server1\folde r1\%.xml]'
[/code]

Message field is like
Finished File(s) [\\server1\folde r1\k382492923-20070914.xml]


This is more for curiosity then anything else.
I currently have it working as:
where message like 'Finished File(s) %\\server1\fold er1\%.xml%'
but it doesn't seem as efficient.

[deepuv04]

Hi,
Try the following query

[code=sql]
Select replace(replace (Message,'[',''),']','') as Message,*
From table1
where message like 'Finished File(s) [\\server1\folde r1\%.xml]
[/code]
Thanks