Re: [GENERAL] INSTR() like function?

[Tom Lane]

"Michael Loftis" <[EMAIL PROTECTED]> writes:
> IE are the characters A or B or C or D in the string "dogma" would be
> INSTR('ABCD','dogma');

See the regular-expression match operators (~ and ~*).  The above would
be
        select  'dogma'::text ~* '[ABCD]'::text;
assuming you meant you wanted case-insensitive match.

                        regards, tom lane