1 Reply Latest reply: Jul 4, 2011 6:09 AM by 873005 RSS

    Square bracket [] wild card is not working

      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..