try to use
select * from test where msg like '%[x]%'"
there should be some value in the braket and braket closed.
quote:Originally posted by vincentc
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.