Am I doing something stupid trying to escape an underscore in LIKE? Version 7.1b3 richardh=> select * from foo; a ----- a_c a_d abc (3 rows) richardh=> select * from foo where a like 'a_c'; a ----- a_c abc (2 rows) richardh=> select * from foo where a like 'a\_c'; a ----- a_c abc (2 rows) richardh=> select * from foo where a like 'a\_c' escape '\\'; a ----- a_c abc (2 rows) richardh=> select * from foo where a like 'ax_c' escape 'x'; a ----- a_c (1 row) - Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
