Re: Select query with GROUP condition thens order by alphanumeric

[Chad Bourque]

Chu,

I think you are going to have to write a function that takes a string and returns a string. In that function, iterate the string, and translate each character into another character that will sort how you want. I would think this would be slower than you'd like, too, but I can't think of another way since the various characters can be anywhere in the string.

If you have to have that special sorting, I would probably add another column to the table for the sort value and do the translation I mentioned above on insert and update triggers, populating that new column. Then, you could just order by that column.

HTH,
Chad