Array of characters in LIKE predicate

[nnani]

Thanks skwa,

The query was done right.

[nnani]

This was the sample query that worked for me.

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