> How do I exclude any records where the path column is > '/realtors/Kokomo/%'?
You're too funny... you gave the answer on the subject line of your e-mail :-) Read http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html Scroll down past the section on LIKE and you'll find: expr NOT LIKE pat [ESCAPE 'escape-char'] Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]