sql,query
Thank you very much. One more thing, would 0000250k be the same as 2500 x -3 ? ie -7500 Thanks again. > > > On Sun, 10 Mar 2002, Roger Baklund wrote: > > >>* Vincent Stoessel >> >>>Hello, I am trying to convert this weird cobol style number into a >>>regular integer. I got it from a fixed length text file. >>> >>[...] >> >>> If the value is negative, the right most column will contain a >>> >>> special character: ] = -0, j = -1, k = -2, l = -3, m = -4, >>> >>> n = -5, o = -6, p = -7, q = -8, and r = -9. >>> >>> >>>example numbers: >>> >>>I have 1500 numbers that look like this! the rest are "normal" integers. >>>Any help would /really/ be appreciated. TIA. >>> >>> 000125] >>> 000020] >>> 000025] >>> >>As ] is -0, these numbers should be -1250, -200 and -250... right? >> >>What is the problem? >> >> >> > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
