Hope someonecan help.
 
Here's the problem.  Working on a drill down report where I look for all WIP variances within GLTRAN (use the GLACCT field) then I take that record and fild the associaed work order for the transaction.  Sound simple but BKGLTRANS.BKGL.TRN.INVC is a string and WORKORD.MTWO.WIP.WOPRE is a Double  so I do the following:
 
{WORKORD.MTWO_WIP_WOPRE} = val(left({BKGLTRAN.BKGL_TRN_INVC}, 6))  <-- 2 SP +#
 
This appears to work most of the time but every now and then I get one that's missing.  I looked in WORKORD and there is a prefix of 1160 there and I looked in BKGLTRAN and the entry is "__1160- 1____" It works for every thing except the example above and one other.
 
Any ideas would be a great help.
 
Tim