how to search for two characters in any sequence, with or without alphanumeric characters in between [message #657975] |
Tue, 29 November 2016 13:38 |
namitanamburi
Messages: 35 Registered: March 2009
|
Member |
|
|
I would like to search if both C and 2 are in a column. The search has to be case sensitive.
There may/may not be any alphanumeric data between them.
select 'data_available' from dual
where REGEXP_LIKE('C275xAa', 'C2|2C|C?2|2?C');
select 'data_available' from dual
where REGEXP_LIKE('C275xAa', 'C2|2C|C?2|2?C', 'c');
Above code is not case sensitive.
Can you help me with
1) should be case sensitive.
2) may/may not be any alphanumeric/special characters between them.
3) can be any sequence 2C, C2 etc or 2ggfghC or Cjjhjj$55@2
Please advise
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|