Hi Vijay,

Thanks for the advice, but I was really wanting to use a boolean parameter, the True/False radio buttons of boolean parameters will be easier for users, one click not...

abhijeetv (9/29/2008)

---

You can add a separate CASE for checking if the parameter is NULL and use the BETWEEN clause only when it is not null.so the WHERE condition wont...

Hi abhijeetv

I've just tried your suggestion, but it failes on the second option,

2. ...

These are my parameters

@TMC_pNAME_ID VARCHAR(500) ,

@TMC_pROLE_TYPE_ID INT ,

@TMC_pCATCHWORD VARCHAR(500) ,

@TMC_pStates VARCHAR(500) ,

@TMC_Status_label VARCHAR(500) ,

@TMC_pStart_date datetime ,

@TMC_pEND_date datetime

The multi value parameter which I started this thread on is the @TMC_pNAME_ID...

Firstly. Thanks to everyone for their help, However i'm still stuck.

I've now got two problems

1. I've followed the link from Medhivanan and added the following to my...

bkDBA (9/23/2008)

---

But I'd really like to do this using SQL as much as possible, Do you know if I'd be able to use a case statement using an 'in' and...

Then your custom code would do something like this:

[font="Courier New"]    Function BuildWhere(ByVal NameList As String) As String

        Dim strWhere As String = "Where "

        Dim strNames As String() = NameList.Split(",")

        Dim i As Integer...