[thelist] Sorting with SQL

Joshua Olson joshua at waetech.com
Wed Sep 24 10:43:20 CDT 2003

----- 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


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.

More information about the thelist mailing list