Hi group Access has a datatype (I don't remember the name) which is a kind of boleaen; it represents Yes/No, true or false. When I try to translate that creating a table in MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result. Anyone? Ann --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php