ILIKE is probably better – without an escape: WHERE field1 ILIKE field2 ESCAPE ‘’ You could also try: WHERE upper(field1) = upper(field2) David J. From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Allan Kamau I do have a field for which I want to perform a join with some other field in another table using case without case sensitivity perhaps using ~*. One of this fields may contain + characters or unbalanced parenthesis. Is there a way or some function that may mask out the regexp awareness of any of these characters if they appear the field values. Should I need to write a function to escape each of these characters by placing a "\" character before it? Allan. |
