Sort Question?

[C#Schroeder]

I am new to SQL and am trying to sort some information. The data is
being sorted, but not in the way I desire it to be.

Example: Sorted Table Desired Sort
Product Name Product
Name
------------------------------
-------------------------
Test-1
Test-1
Test-10
Test-2
Test-11
Test-3
Test-12
Test-4
Test-2
Test-10
Test-3
Test-11
Test-4
Test-12

Thanks for any help.

 

[C#Schroeder]

I am new to SQL and am trying to sort some information.  The data is
being sorted, but not in the way I desire it to be.

Example:  Sorted Table                                   Desired Sort
     Product Name                                           Product
Name
------------------------------
-------------------------
    Test-1
Test-1
    Test-10
Test-2
    Test-11
Test-3
    Test-12
Test-4
    Test-2
Test-10
    Test-3
Test-11
    Test-4
Test-12

Thanks for any help.

Sorry Wrong forum. I thought I was in the SQL forum.

 

[Nicholas Paldino [.NET/C# MVP]]

Anthony,

Well, to answer your question, you are going to have to sort it based on
the numeric value after "Test-".

If you know that the first five characters are always going to be
"Test-", then you can use this order by statement:

order by convert(int, right(<field>, len(<field>) - len("Test-")))


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I am new to SQL and am trying to sort some information. The data is
being sorted, but not in the way I desire it to be.

Example: Sorted Table Desired Sort
Product Name Product
Name
------------------------------
-------------------------
Test-1
Test-1
Test-10
Test-2
Test-11
Test-3
Test-12
Test-4
Test-2
Test-10
Test-3
Test-11
Test-4
Test-12

Thanks for any help.

Sorry Wrong forum. I thought I was in the SQL forum.