Subject Re: Odp: [firebird-support] Computed index
Author Tim Ward
On 10/10/2013 07:31, Svein Erling Tysvær wrote:
 
What if you try:

    IIF( (MYFIELD in (1,3,4,5,7,8,9,11,12,13)), MYFIELD, -MYFIELD)

and

    IIF( (MYFIELD in (1,3,4,5,7,8,9,11,12,13)), MYFIELD, -MYFIELD) > 0

I'll give that a go when I come back to this issue, thanks.

-- 
Tim Ward