Ninja's_RGR'us (11/26/2008)
Since when can DateofBirth = "" ???A date value is set to a date.... or null, period (sql server side).
Don't bite my head of now! I meant case when DateofBirth = '' then NULL else DateofBirth end. That was a typo and yes, you can set a date as '' because then you will just get the default. I normally test before I post here. By the way when you are programming in e. g. Visual Basic the you do use "".
Thanks for pointing out the typo.
:hehe::hehe::hehe::hehe:
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)