I have a query which searches a range, but I need to modify it to use all wildcards.
If I use:
WHERE (EM_PAYROLL_UNIT >= '0%%%') AND (EM_PAYROLL_UNIT <= 'Z%%%')
it works, but if I use
WHERE (EM_PAYROLL_UNIT >= '%%%%') AND (EM_PAYROLL_UNIT <= '%%%%')
It does not work.
Is it possible to make this work, or do I need to create 2 queries based on the parameters passed to the query.
Denis
Programmer, Canada
If I use:
WHERE (EM_PAYROLL_UNIT >= '0%%%') AND (EM_PAYROLL_UNIT <= 'Z%%%')
it works, but if I use
WHERE (EM_PAYROLL_UNIT >= '%%%%') AND (EM_PAYROLL_UNIT <= '%%%%')
It does not work.
Is it possible to make this work, or do I need to create 2 queries based on the parameters passed to the query.
Denis
Programmer, Canada