I have this following where clause in a query that is being frequently used
where COLUMN_A = 'ABC' and COLUMN_B IN ('d','e','f')
and COLUMN_C <> 'XYZ' and COLUMN_D NOT IN ('p','q')
and COLUMN_E LIKE 'hij%' and COLUMN_F NOT LIKE 'lmn%'
now wht i would like to do is remove hardcoding from this query. I was thinking about having a central repository like a MetaData table which will store all the values. But then how would i join this metadata table for LIKE and NOT LIKE cases.
View Complete Post