Here is how to do it in mysql http://www.mysql.com/doc/en/Cast_Functions.html
----- Original Message ----- From: "John Almberg" <[EMAIL PROTECTED]> To: "Beginners" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 5:21 PM Subject: RE: How to sort a character-type field, numerically > Well, right now I'm doing the sort in SQL. That's the problem. Since its a > character-type field, I can't get MySQL to sort properly. > > I guess I could use DBI::fetchall_arrayref to fetch all the data at once, > then sort the array of records the way I need them. However, what I'm hoping > for is some SQL expert to tell me this would be a silly approach! > > -- John > > > -----Original Message----- > > From: Wagner, David --- Senior Programmer Analyst --- WGO > > [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, September 25, 2002 4:48 PM > > To: 'John Almberg'; Beginners > > Subject: RE: How to sort a character-type field, numerically > > > > > > > > You should be able to sort it numerically if I understand where the > > data is coming from. Could you provide a snippet of the code and > > from there > > it should not be that hard to provide code to sort numerically. > > > > Wags ;) > > > > -----Original Message----- > > From: John Almberg [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, September 25, 2002 13:18 > > To: Beginners > > Subject: How to sort a character-type field, numerically > > > > > > I'm trying to sort a SQL table that contains a character-type field that > > contains mostly numbers. This field always contains either a number or a > > number followed by a character. Like '57' or '57a'. > > > > I'd like to sort the table *numerically* on this field, not > > *alphabetically* > > on this field. That is, I'd like the table to be sorted like: > > > > 1 ... > > 2a ... > > 3 ... > > 4d ... > > > > NOT like: > > > > 1 ... > > 11 ... > > 111a ... > > 2a ... > > 22 ... > > > > See what I mean? This is a common problem, I think, when you sort an > > character type field that contains numbers. The sort comes out all wrong. > > > > It would be great if I could get rid of the characters, then I could make > > the field a pure integer and the sort would work great, but that's not > > possible (or easily possible.) > > > > A pseudo-code solution would be SELECT * FROM table ORDER BY > > INT(char-field), but unfortunately even MySql doesn't have such an INT() > > cast funtion. > > > > I'm asking this perl group, because I suspect that my only solution is to > > sort the result set in perl. Am I right about this??? > > > > Thanks. > > > > -- John > > > > > > > > -- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > ********************************************************** > > This message contains information that is confidential > > and proprietary to FedEx Freight or its affiliates. > > It is intended only for the recipient named and for > > the express purpose(s) described therein. > > Any other use is prohibited. > > **************************************************************** > > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
