[Info-ingres] Am I doing SIMILAR wrong?

[Roy Hann]

Martin Bowes wrote:

> It's something going wrong with the period...or our interpretation of it...!

So it's not just me then. I don't know whether to be pleased or not.

For now I've worked around it by deleting the periods first:

  select * from foo where replace(name,'.','') 
        not similar to '[-''ABCDEFGHIJKLMNOPQRSTUVWXYZ]+'

Roy

PS, I'm not using [:UPPER:] or [A-Z] because my real character class
contains additional accented characters. Just listing them all seems
aesthetically smoother.  :-)