MySQL 4.0.14 Trying to run a select statement on field (varchar) containing values (e.g. ':', '/', '\') returns blank recordset although records exist.
select * from table1 where field1 = 'c:\folder\filename.extension' Is there any particular rule to follow. I inserted the same row twice and run a Distinct() returned only one row. regards ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]