[thelist] Sorting with SQL

Rob Smith rob.smith at THERMON.com
Wed Sep 24 15:46:31 CDT 2003

here ya go, rob

create table strings
 ( string  varchar(20)  not null )


Neat. Although the example worked nicely I might add. I tried to use my
column of varchar but ran into a SUBSTRING error:

Syntax error converting the varchar value '2A10 TZ  BN' to a column of data
type smallint. 

The original data in the column was: TEK 2A10 TZ  BN. What data type should
I use or one do you think will work?



More information about the thelist mailing list