Re: Possible ways to sort numbers stored in a varchar column?

Thanks i also found the function CAST which works ok. So now i have three options: CAST LPAD Adding zero Any other sugestions are welcome! Quoting [EMAIL PROTECTED]: > Test USER <[EMAIL PROTECTED]> wrote on 11/23/2005 07:36:43 PM: > > > Is the only way to sort numbers stored in a varchar colum

Re: Possible ways to sort numbers stored in a varchar column?

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? > > --

Possible ways to sort numbers stored in a varchar column?

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 -- MyS