You could update all your tables.
But there's no way in any of the supplied tools to do this.
SQL Server MVP
Quote:> isnull() build-in function replaces a NULL value by a
> specified value. Is there any parameter on a databaseor
> for a seesion that can be set to make NULL substitution by
> a specified value automatic.
to make NULL substitution by a specified value automatic. <<Quote:>> Is there any parameter on a database or for a session that can be set
No. Imagine the mess that (n) sessions with (n) different NULL
substitutions woudl be!
However, you can use the DEFAULT clause to something like what you are
asking for. Or you can do an UPDATE at the end of your session.
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
One option (in addition to others) is to create Views.
Whiles using a find command in an integer field that has only integers
(finding all values < 1), it returns records that also include null
values, i.e. there are some records that are blank. They are blank
because the rest of the data in the record does not merit a value in
the the integer field. Also the null value does not mean zero either.
Zero is a valid result.
I would like to be able to search the integer field for all integers
include zero but not return the records with the null value.
Anyone know how this can be done with filemaker 4.0