k_murli_krishna
asked on
Wild card characters search
1) When we have % and _ in data of column in table, how do we search for these values using wild card search?
2) What I mean is:
SELECT C1 FROM T1 WHERE C1 LIKE '%_AB%_C';
In this case first %_ should be treated as characters of data and second %_ as wild card characters.
2) What I mean is:
SELECT C1 FROM T1 WHERE C1 LIKE '%_AB%_C';
In this case first %_ should be treated as characters of data and second %_ as wild card characters.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER