Test USER <[EMAIL PROTECTED]> wrote on 11/23/2005 07:36:43 PM: > Is the only way to sort numbers stored in a varchar column to use lpad? > Are there any other columntypes that allow both characters and > numbers that can > sort numbers correct? > > ------------------------------------------------- > FREE E-MAIL IN 1 MINUTE! > - [EMAIL PROTECTED] - http://www.pc.nu >
You can try adding zero to the column. It's a function acting on a value so any chance of using an index is eliminated but you can get your columns as numbers that way. To answer your second question, no. Fields are either strings or numbers but never both. Shawn Green Database Administrator Unimin Corporation - Spruce Pine