I have a Sqldatasource with this SQL:
Select * from Table1 where X not like @param
It is working fine, except if @param is a null value, it returns nothing.
I want to modify it such that if @param is null, it returns all value (ie same as Select * from Table1).
How should I rewrite this ?
Thanks
Go to the complete details ...