That's not what WHEN is used for. I suggest you take a look at a basic SQL book.
Jeff Hunter
Forum Rules