Yeah, I know, right? :-) I didn't know you *could* put CASEs in querys; is that a MySQL thing? No, I believe that is part of the ANSI spec. I know SQL Anywhere also supports it. Dave Sent from my BlackBerry device on the Rogers Wireless Network