Hi everybody,

I added an extra table called Membership to my database. I found that I'm unable to use NULLs for the fields, so I have to convert data to not NULLs. I'm doing this in my SP to retreive data.

But now I'm facing a problem of updating the info. I only want to insert/update record if I put some information. However, how now I can detect if I did make changes or not?

I'm converting bit fields to 0, date to GetDate() and varchar field to ''

Thanks a lot in advance.