SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 When Parameter is be null?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sep410
Posting Yak Master

Canada
117 Posts

Posted - 08/11/2008 :  17:37:15  Show Profile  Reply with Quote
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.



Sep

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 08/11/2008 :  17:43:02  Show Profile  Visit tkizer's Homepage  Reply with Quote
Use the COALESCE function to handle it in the WHERE clause.

WHERE CaseID = COALESCE(@Param1, CaseID) AND CaseIDText = COALESCE(@Param2, CaseIDText)

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 08/12/2008 :  03:04:44  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
or

WHERE (CaseID = @Param1 or @Param1 is null) AND (CaseIDText = @Param2 or @Param2 is null)

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000