Probelm with Concatenating two Parameters in WHERE CLAUSE
Posted on 2011-04-27
Hi= my database doesnt have the best structure but I cant modify the tables.
Heres my problem:
I have four parameters coming into my query:
sample data is:
So, in my WHERE CLAUSE I need the following since my users are selecting from four string type drop downs:
A.MONTH_FW IN (@StartMonth,@EndMonth )
A.YEAR_FW IN (@StartYear ,@EndYear )
-this doesnt work since the months and years could be mismatched:
i.e., 4 2011,
Anyway can some one recommend the best way to match these two date oarameters to the database columns?
I tried where (a.month_fw + a.year_fw) but I dinnt get the right results