Another bug with "create table ... select ..." statement and control flow functions: see Threads for July 2002. This bug affects Version 4.0.3 (I have experienced it with LinuxRH7.3, Windows NT SP6, Windows 2000 SP2). Try this:
"create table ciccio select if('2002'='2002','Y','N')" "select * from ciccio" The query returns always 0 values for that making-me-mad field. I think that now I have to wait for 4.0.4 version to see this bug fixed, am I wrong? Thanks Danilo Maurizio --------------------------------------------------------------------- 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