[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