I'm working with a text file, using it as a datasource, that an information provider puts into our site daily. One of the fields is "InterestRate" and the contents are values like "14.0005%" and "8.5000%". There is no problem as long as I just want to display this value.
But now I want to sort the rows on the interest rate, and of course since it's a character field, it sorts 14.0005% as lower than 8.5000%. How can I convert the value from characters to numbers in the SQL? We're using the Microsoft .txt/.csv driver. Since the file is put in our site daily by the information provider, I can't change the file at all, because it's going to be replaced with a new one tomorrow. Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
