CtrlAltDel,

That won't work because what if @filter1 is NULL and col3 is NULL? The SELECT won't return anything if @filter2 has a value.

Basically, if your database fields contain NULLs,...

Jonathan....I'm not sure if your solution will work. For example:

@areaDesignatorID will only be NULL if the user doesn't want to search by that option on the search form. ...

Hi Frank,

Regarding your last comment, I can't really place a default in a VARCHAR, because say the user leaves it blank on the form.....like say a Postal Code (or City...

Sorry, I started with a simple question and now asking something different. My initial post was due to a problem I was having with ISNULL. Let me use...

Great. I was hoping for that.

I thought the following would evaluate to true if @areaDesignator and AreaDesignatorID were NULL...but of course it doesn't:

WHERE...

Sure Frank....I'd be glad to. This approach is a little specific to my needs so you will have to read between the "lines". First, some setup info to...

GuardData,

I ended up using a cursor approach. What I do, is read in my list an item at a time, "normalize" it (the part that I was hoping the...

DataGuard,

I wanted to do the "normalization" in the SELECT statement (thus the reason for a function). From your post, it sounds like that won't be possible and as far...

GuardData,

How do I do the FUNCTION RETURN after the SELECT is executed?

--Lenard

Frank you can use OUTPUT parameters.......have a look:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q262499

GuardData, the table that I'm binding actually has a list of masks and "@sql" which I select. But before I...

Frank that won't work in a function. Don't you have to explicitly return a variable? Here is what I've come up with so far but am having some...

Andy,

How would you code something like this in Dynamic SQL? I basically want to grab the value of the field and return it.

SELECT @telephone = Telephone FROM...

Yes, I would be passing an ID as well. I forgot to show it.

Regarding the lookup table....I want to avoid that. I guess dynamic sql would...

If you are trying to share variables between stored procedures, have a look at this

http://www.algonet.se/~sommar/share_data.html

--Lenard

ccundy,

Here is a link you may find of interest:

http://www.algonet.se/~sommar/arrays-in-sql.html

He has a couple of functions that convert lists into tables.

--Lenard