MySQL doesn't have a boolean type, right? So what is the preferred way to create a column to hold a true/false value? I've been using CHAR(1) DEFAULT "N", how's that? Is there some value that PHP would intrinsically recognize as true/false after a select, like 1 and 0? thx -- mike[at]nthwave.net llemekim YahooIM 415.455.8812 voice 419.735.1167 fax