[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