>>>Is there a function or command to do this? Without using a loop.
>>
>>I don't think so. You will have to write the loop, or use some other workaround.
>
>Why not? You can create two cursors, APPEND FROM ARRAY and than use queries to compare those cursors. It would work if data in array columns is of the same type, but still. :)
That is approximately what I had in mind when I wrote "some other workaround", but I didn't want to elaborate.
Using SAVE TO (as implied in the other reply) may solve the problem with different types of values. This would not require a loop. However, I did not try it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)