Hi Michael, Thank you for your reply. We had read the LIKE doc but obviously missing the fact that "the backslash already has a special meaning in string literals, so to write a pattern constant that contains a backslash you must write two backslashes in an SQL statement. Thus, writing a pattern that actually matches a literal backslash means writing four backslashes in the statement. " Mickael. -- See the "Pattern Matching" section in the "Functions and Operators" chapter of the documentation: http://www.postgresql.org/docs/8.0/static/functions-matching.html The documentation under "LIKE" discusses issues regarding the escape character (the backslash by default). -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
