jcelko212 32090 wrote:
The case expression returns a value of a particular data type. In your example, you're sorting on a numeric, without regard to what the original column was. This would seem to have an awful lot of overhead as well as possible incorrect values and a different correlation if the original column was a character data type.
Are you sure about it?
Can you elaborate on it please? I cannot see your case.
But just from an aesthetic viewpoint, this is a kludge to get around the lack of a standard feature.
I never heard of any art excibition showing new (or traditional) trends in SQL coding. I don't think people would appreciate the aestetics of it anyway.
As for myself - I'm trying my best to make the code working with no errors, and with no performance degradation, so neither me nor anyone else would need to open it again, and no aesthetic confrontations would come from it.