i have a query select * from tblUser where Salary > 5000 and Department = 'IT'
But some times i will pass Salary value only. that time I dont want to check the second condition
How to achieve this Goal ? ISNULL is ok for it ?
What actually ISNULL represents?
...
Go to the complete details ...