>>>>I think your approach is probably better. Except a little more characters to type when making changes <g>. Thank you.
>>>
>>>You can always pass the var to a function and check it there - you could set it to an empty date if it's null or check it for a valid date within a range if it's not null, etc....
>>>
>>
>>Good suggestion. I can add more "features" to the function that checks for empty or null date. Thank you
>
>Except that I'd still go for the one-liner expression in a SQL statement. Today's machines may be fast enough for that, but still the overhead of calling a function for each record may be too much - and may get of your nerves if it happens while debugger is on.
My purpose of using the "empty" expression is not in the SQL statement.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
