Posted by DarthDubroc on 10/24/06 19:25

Hi My Name is Danny,

I have a problem with the Order By Clause.

My scenario is that I have Varible Data inside a Table ie: A123, B123,
1, 2 , 10, 11,13, 33
(this is just Pseudo)
Well when I do an Order By Clause it checks the numbers and The
Alphabets. The Alphabets with the numbers Work accordingly but the
numbers are different. It checks the Numbers ie: 1, 10, 11, 13, 2, 33.
Do you think that you can help me out with this Situation. I think I
have to do some sort of Advance Order By Clause. The only problem is
that I do not know how. Another solution is the Case Function. I just
started working with SQL and I'm very Intermediate with this Program.
If you can help Thx in advance, If not thx for reading this email and
giving me some of your needed time.

Thank you ,

[Back to original message]