|
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. -- [ Picked text/plain from multipart/alternative ] Can this be done, via an sql call? I have a field, it's 20 char long, left justified.. It has things like: Accounting Education 110 1101 220 2234 The problems is sorting... Because it's not a numeric field, and there are are no '0's infront of the number to make them the same length or right justified, their not sorted correctly... Is there a way in a sql statement, to check the field to test if it's numeric, and if its, a valid number, (cast) it as an integer, and sort it that way? Just looking for an idea... thanks
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
