I don't have a trigger set up as the end user is the one to finally decide what they want to see. Yes there can be a time when they...

Thanks a bunch worked great

Sorry thought I had deleted the first one

Thanks...I am getting this error:

Invalid length parameter passed to the SUBSTRING function.

THANK YOU GUYS!!! Both ways worked great. In this case the "or" worked a little faster. But I'm printing this post for next time.

Now can you tell me if ther...

Yes, missed that. Works great!! Thanks a bunch!

Almost!!

The query works great but the Visual Studio report stills needs a little tweaking. The report runs fine when I enter the multi-valued parameter and leave the parameter range null,...

Thanks!!! That worked like a charm. I wish everything I'm trying to learn in SQL was that easy!

Thanks, it worked great!

Now that I that working, do you have any idea how I can set up the report in Visual Studios so the end user can pick...