|
Posted by Jack Vamvas on 01/18/08 10:26
Assuming you can do this , split the column , and then order on the basis of
the Integer
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"SQLLearner" <Anthony.Schroeder@gray-research.com> wrote in message
news:c396db7b-2138-4db5-bb7d-c6f3c0e0d41f@c23g2000hsa.googlegroups.com...
>I am new to SQL and am trying to sort some information. The data
> isbeing sorted, but not in the way I desire it to be.
>
> Example: Sorted Table:
> Product Name
> -------------------------
> Test-1
> Test-10
> Test-11
> Test-12
> Test-2
> Test-3
> Test-4
>
> Desired Table:
> Product Name
> -------------------------
> Test-1
> Test-2
> Test-3
> Test-4
> Test-10
> Test-11
> Test-12
>
>
> Thanks for any help.
Navigation:
[Reply to this message]
|