Thanks for the input from Everyone. I fixed my problem by using this script.

http://www.sqlservercentral.com/scripts/contributions/624.asp

Again thanks to everyone.

I really do appreciate your help. I have included the sample data and SP.

Sample Data Table

• ID - Int
• PDT, Proj, WrkProd - nvarchar

ID PDT ...

The isnull worked well for the int datatype, now what happens if I have a parameter that is nvarchar?

ISnull doesn't return anything. It says 0 Rows affected.

Thanks in Advance...

Npeeters,

Thanks for your response. I will try this and let you know if that works for me.

Thanks again.