Hi guys,
Stuck again with a SQL statement in asp.net
My SQL statement:
string query = "SELECT Employee_ID, Nick_Name, First_Name, Last_Name " +
" From tbl_Employee_Data Where jobfunction = " + System.Configuration.ConfigurationSettings.AppSettings["JobFunction"].ToString() + " AND BRANCHIDE = " + Session["BRANCH_ID"].ToString() + " Order By Nick_Name";
I want to include in the where part: WHERE current = NO (false, 0) tried them all
A bit of background, as you can probably tell the variable fro the JobFunction string comes from the app settings file so I am not able to just add the current=NO in the SQL statement. The Statement works as is but I want to filter out additional records which
are marked as current
How do I work around this?
Thanks in Advance
Ben
Go to the complete details ...