I use the following function in Oracle SELECT decode(status,'A','Active','L','Active','Former') FROM Table
What it means is: if table column status = A, return "Active", if status=L, return "Active", else return "Former" in the select statement. Decode in mysql has nothing to do with this functionality and I didn't see a function while browsing the docs online that did this. Is there an equivalent function in mySQL? Thanks ********************* Jon Rosenberg www.DeanForAmerica.com www.OhioForDean.org
