[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