|Subject||Re: [ib-support] Substring function|
> The one with data is called STATUS. The one to populate is called BAL_RET. The data going into the BAL_RETfield is based on the first 2 or 3 characters in the STATUS field. I can run it multiple times for the 2 or
3 different values in STATUS.
>You can also use something like this (in SP):
> This only has to be done once. After the data is migrated, the software stores the correct value.
IF (status LIKE '_AB%') THEN ...
(which is equivalent to
IF (substring(status from 2 for 2) = 'AB') THEN ...