Dynamic Where Clause IN Sql Statement -Reply

[Ashok Datta <adatta@DOAS.STATE.GA.US>]

Hi Sam

Depending on the user input you move the appropriate value in your
WHERE clause. Here is a example:

Let $Q = ''''

Let $Where_Match_Amounts =
 'abs(MONETARY_AMOUNT2) '   || '=  abs(MONETARY_AMT_VCHR)'

Let $Where_Cash_Actuals =
           'AND DST_ACCT_TYPE IN '    ||  $Q  ||  'CAS' ||  $Q


SELECT *

 FROM  TABLE_NAME

 WHERE [$WHERE_MATCH_AMOUNTS]
              [$WHERE_CASH_ACTUALS]

I hope it will help. Thanks