[thelist] Sorting with SQL

[Keith Underdown]

On Wed, 24 Sep 2003 09:35:13 -0500, Rob Smith <rob.smith at THERMON.com> 
wrote:

>> it would help to know which database you're using...
>
> rudy,
>
> 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

Are these hierarchic? In other words is the alphbetic part really the key 
to a parent object (Product Line to Product for example). If it is it 
would be better to get the analysis right and use the foreign key of the 
parent as the first part of a multiple sort.

Keith

-- 
Keith Underdown (Managing Director)
The Q Consultancy Ltd
KALIDO Information Archtectures Specialists
+44 7798 934782
www.qconsultancy.co.uk