NULL or empty ?

[Camel]

Hello Experts,
Recentlly i start developing an application in VB.net and SQL server. On the server there are some fields that can be empty. I was wondering what is the best practice, use empty values or NULLs for the non required fields?

In the tables i got dates, currency, strings.
The strings are the easyest. For the currency i could add a boolen flag to mark if there was a paiment or not, but what about the date? is a NULL value prefered than 01/01/1900

Camel

 

[donutman]

Up to you. If you put in a default date, what will it be...and what will it mean to the application and/or user?
-Karl

[red] Cursors, triggers and user-defined functions are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]