So far I have worked with the Visual FoxPro Database. I rarely insert NULLs intentionally, they usually appear from the result of an outer join.
>You are correct that this function can be used on any other type as well. In fact I found out this morning that I need to apply it to other type fields. This is one of the work I have to do when moving from VFP to SQL Server, search and change how the program "deals" with NULLs. I rarely used NULLs in VFP application whereas in SQL Server this value is used a lot.
>Thank you.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)