[thelist] Sorting with SQL

rudy rudy937 at rogers.com
Wed Sep 24 17:40:17 CDT 2003


> The original data in the column was: TEK 2A10 TZ  BN.

dude, you said

     > 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

i should like to point out that 2A10 is NLNN and that unexpected letter 
in there is what caused the CAST(... AS SMALLINT) in my query to barf

any other whoopsies before i roll up my sleeves again?

(it'll have to be tomorrow anyhow)

(or you could have a go -- it's not hard, give it a try)


rudy





More information about the thelist mailing list