I've created a table contains a column with varchar(3) data type.
When I query "select * from test where msg like '%[%'",
it doesn't work.

Can anyone help me?
Thanks a lot.

Hi

There are 2 methods to do this :-

select * from test where msg like '%/[%' ESCAPE '/'
select * from test where msg like '%[[]%'

As [ is a wildcard you cannot use this as you would search for a 'normal' character.

Check out BOL and search for escape characters for further info.

Regards

Nickie

try to use

select * from test where msg like '%[x]%'"

ie. msg=window[xp]

there should be some value in the braket and braket closed.