Let put this way.
I wish to find a string i.e [CONN-3] connectors only for field termination of 1127 cable. And this string is inside say table1 with the field (MyString) and data type is text
when i perform a SELECT query i.e SELECT * FROM table1 WHERE MyString LIKE '[CONN-3] connectors only for field termination of 1127 cable'
And it's return 0 row. I try using "=" rather than LIKE, but is not allowed because the data type is text.
When i search at the SQL Online documentation, the eg give to me is , LIKE '[M-Z]inger' searches for all names ending with the letters inger that begin with any single letter from M through Z (Ringer)..
which mean my SELECT query won't work.
Originally posted by r937
sorry, i don't understand what string you wish to find
if you wish to find exactly that string, use equal, not LIKE
if you wish to find any string with something in square brackets at the front, try