• Sean Lange's code works perfectly ..with index seek

    WHERE (@p_flag = 1 AND moveFlag = 26)

    OR (@p_flag <> 1 --if this is a bit I would use = 0 instead of <> 1

    AND moveFlag > 26 OR moveFlag < 26)

    Thank you all...