Ann Myhre wrote: >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? > Use type `bool'. This is an alias for tinyint(1), with values 0 or 1. Charlie --------------------------------------------------------------------- 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