Thanks skwa,
The query was done right.
Array of characters in LIKE predicate
Moderator: NorbertKrupa
Re: Array of characters in LIKE predicate
This was the sample query that worked for me.
Thanks skwa
Code: Select all
select pm_id,pm_name,
case when regexp_like(pm_name,'((ab)|(kfd)|(nm))')
then 'yes'
else 'out'
end
from tempdb.litab;
pm_id | pm_name | case
-------+----------+------
1 | abkd | yes
2 | dfgkl | out
3 | kmnolk | out
4 | zzzxxbsd | out
(4 rows)
Thanks skwa