Re: Help, any convert(legacy) function? in mysql?

2002-03-10 Thread Vincent Stoessel
sql,query Thank you very much. One more thing, would 250k 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 integ

RE: Help, any convert(legacy) function? in mysql?

2002-03-10 Thread Roger Baklund
* Vincent Stoessel > Thank you very much. One more thing, would 250k > be the same as 2500 x -3 ? ie -7500 No, I don't think so, but I must add a small disclaimer: I have worked with cobol many years ago, and your numbers seems familiar, but I don't really remember, I am only guessing... :)

RE: Help, any convert(legacy) function? in mysql?

2002-03-10 Thread Roger Baklund
* 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 =