[thelist] SQL Order By Clause
Shashank Tripathi
sub at shanx.com
Wed Jul 25 18:43:41 CDT 2001
Michele, Scott,
| Whaddya doin with that field being text??
Excellent suggestion!
If you have a column that is designed to hold only numbers, use a numeric
data type, such as INTEGER, instead of a VARCHAR or CHAR data type. Numeric
data types generally require less space to hold the same numeric value as
does a character data type. This helps to reduce the size of the columns,
and can boost performance when the column is searched (WHERE clause) or
joined to another column.
Otherwise, you could use some conversion function (to_integer(item_no) or
whatever the SQL Server equivalent is..)
Shanx
More information about the thelist
mailing list