Posted by Paul on 02/07/07 09:10

Thanks to everybody for clarifying this for me. It still doesn't solve
my problem of how records that should be NULL are actually empty
strings - this should not have happened and I still cannot see why it
should have. Maybe it is our application after all. But if it was the
application then I would have hoped to see the same behaviour on
Oracle, but I do not, all the equivalent fields on Oracle are NULL
rather than ''.

If I do find anything I will post the results back here.

Thanks to everybody for their time,

Paul

• Next in forum: Re: NULLS and ''
• Prev in forum: Re: Stored procedure and SQL Job Agent Task
• Thread view: Re: NULLS and ''

[Reply to this message]