You could use designer to create a condition like: @variable(‘prompt’) IN (FIELDA,FIELDB)
Are you sure though that an IN is more efficient than an OR? As I understand it most SQL Optimisers convert an IN statement to multiple ORs anyway.
Kevin Charleston
SA Container Depots
Cape Town, South Africa
But how can I create this???
select…
from…
where
‘variable1’ IN (FIELDA,FIELDB)
<<