Here is the documentation for CASE and IF
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
On Jun 3, 2004, at 8:33 PM, James KATARSKI wrote:
Harold and Brent,
Thanks for your help. I tried Brent's solution first, but the MySQL client didn't seem to like the IF statements.
The case statements worked sweet though.
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]