Re: [GENERAL] Issue with order by for type varchar

Thanks Martijn. Simon Kelly Java Developer Information Systems Development Information Technology Shared Services Ministry of Health DDI: Mobile: http://www.moh.govt.nz mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 13/09/2006 01:33:15 a.m.: > On Tue, Sep 12, 2006 at 09:51:20AM +1200,

Re: [GENERAL] Issue with order by for type varchar

On Tue, Sep 12, 2006 at 09:51:20AM +1200, [EMAIL PROTECTED] wrote: > Hi All, > > I am trying to order a select by the primary key which is a varchar field. > > 1. the varchar always contains 28 characters. ( and, yes, I know the irony > of using a variable array on a known fixed length field )

[GENERAL] Issue with order by for type varchar

Hi All, I am trying to order a select by the primary key which is a varchar field. I have two known conditions, 1. the varchar always contains 28 characters. ( and, yes, I know the irony of using a variable array on a known fixed length field ) 2. the content of this field contains only the c