hi,
I want to do something like this:

Select * From TEST_TBT
If (i=1) Then
Where Field_1 = 'AAA'
Else If (i=2) Then
Where Field_2 = 'BBB'

Note = i is an Input Parameter in procedure. And this Select
statement is used inside procedure.

Thanks, any help is highly appreciated. Please provide any example..
if u
have.

Feroz