[thelist] Sorting with SQL

[Joshua Olson]

----- Original Message ----- 
From: "Rob Smith" <rob.smith at THERMON.com>
Sent: Wednesday, September 24, 2003 10:35 AM


> It's SQL Server 2k.
>
> In some cases I will have:
>
>    LLL N-N
>    LLL NN-N
>    LL N-N
>
>   .:. Where L stands for Letter and N stands for Number

Rob,

Given that SQL Server 2k can handle substrings (SUBSTRING) and can also tell
you the index of a character within a larger string (CHARINDEX), do you have
enough information to code this on your own, or do you still require
assistance with this?

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com
706.210.0168