Hi all, I know it may seem funny for you but I am really confused right now. I have a select like this: SELECT CaseID, CaseIDText, IntakeWorkerID FROM dbo.tbl_Case WHERE (CaseID = @Param1) AND (CaseIDText = @Param2)
Sometimes user may not enter a value for @param2 how can I handle it in my code. I think I should use like statement but I don’t know how. I should use this code in my vb.net application. Please help me.