ishaan99 (11/13/2006)

SELECT col1, col2, col3, col4, col5, AL1.amount, AL1.quantity

from tab , tab2 AL1

WHERE tab.id = AL1.id

andname like '%bnb%'

and id = 100

AND CASE

WHEN @custom_value='D' then

(AL1.amount between @threshold_value1 and @threshold_value2)

ELSE

(AL1.quantity between @threshold_value1...