all,
i thought this would be simple but also it seems like not so much documentation on regular expressions like REGEXP_LIKE.
iam trying to come up with the REGEXP_LIKE expression to return all and only strings starting with "KE" and ending with any of "C" or "T" or "M"
examples:
keXXXM,
KEqhdgcdt,
KeUSAc
my expression doesnt seem to get the job done: ...where REGEXP_LIKE (b.str, '^KE*[c$mT]','i');
any idea is appreciated.
thanks.