I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator.
I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a.
Ex: If in File A, the value of the field Operator is: 'GE' and the Date_A is 20130410, then the outcome will be this:
Translate: Where Date_A >= Date_B
- OR if the value of Operator is 'EQ', then
Where Date_A = Date_B
I need to use all 5-operator values in the WHERE Statement. Is this doable? Dynamic?
Thank you Experts!