SE7.23: matches "*[\\[\\]\\{\\}]*"-problem

Hi, We need to select all entries of a table where a field has a character of " [", "]", "{" or "}" in it. I tried the statement: select * from table A where f1 matches "*[\\[\\]\\{\\}]*"but it will not work as expected. Any idea how to solve it? Thanks a lot

Peter wrote: > We need to select all entries of a table where a field has a > character of " [", "]", "{" or "}" in it. > I tried the statement: > select * from table A > where f1 matches "*[\\[\\]\\{\\}]*"> but it will not work as expected. Any idea how to solve it? Elsewhere, the rule is to place the ']' as the first character in the character class. So maybe (untested): MATCHES "*[][{}]*" -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>