[thelist] Sorting with SQL

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


<snip>
here ya go, rob

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

</snip>

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?

TIA,

Rob


More information about the thelist mailing list