This discussion is archived
1 Reply Latest reply: Jul 4, 2011 4:09 AM by 873005 RSS

Square bracket [] wild card is not working

873005 Newbie
Currently Being Moderated
Hi All,

i am trying to run 1 simple query but it is not giving appropriate result as per my understanding... Please help

I tried to fetch data using LIKE operator with SQUARE BRACKET [] wild card. Below are the query.

select * from address where homeaddress like '%[@!#]%';

as per my understanding this will return the coulmn which contain @ or ! or # but the the query return the 0 rows and there is many columns which contain these special characters...


Please help..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points