9 Replies Latest reply: Oct 20, 2014 1:10 PM by Dhanushka siriwansha RSS

    mid function in two different character field

    Dhanushka siriwansha

      how can I use mid function in two different character field. I got it one

      mid('policy_no',7,2) as 'class_code',

      also I need

      mid(policy_no,5,2) as class_code,

      need to combine. . .

      tnkz