Link to home
Start Free TrialLog in
Avatar of k_murli_krishna
k_murli_krishnaFlag for India

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.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of k_murli_krishna

ASKER

Thanks, angel.