SELECT <stuff> FROM <table> WHERE <field> LIKE '<Chars>%'
the % is a wildcard and will match up anything after the chars. you can also put one infront to match ANYTHING with <chars> in it. -------------------------------------------8><-------------------------------------------- Many thanks for taking time to answer an "easy" question. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]