Hi,
Martin, are you sure? I would expect the query optimizer to see the <= and cancel the use of the index.
Unless I mis-typed my posting (I didn't keep it), it is fine because the overall condition is not satisfied by a null item.
Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB+44-(0)1604-709200 -------
u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/