Lee

Damnit Bill, that works and I have no idea why! That's going to bug
me now. I don't see why order_id should be NULL, but I'll have to
puzzle it out on my own nickel.

The other answers were good too; I never thought of case or ENUM.

Thanks all.

Lee