Re: Select query with GROUP condition thens order by alphanumeric

[Chu Soon Tan]

Chad Bourque Wrote:
-------------------------------------------------------
> 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


Hi CHad:


yaya......and i also try divide it into 3 query....

first query all special char, then alpha the numeric...but it was damn slow......

i have almost 30k row in the table and the data will keep growing....currently i already feeling the slow process...

jz try do some research may it was some super query that i may not able to think it...:)

thanks


chusoon