Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-08 : 11:58:37
|
Spencer writes "I want to test and update all fields in a record. I need to put this into a stored procedure. Specifically, test for IS NULL and if so change to " ". I need to guarantee that there is no NULL values in any fields before I go on to my next process.
I've tried this:
UPDATE SSFORMX SET JOBNUMBER = " " WHERE JOBNUMBER IS NULL
UPDATE SSFORMX SET FORMNAME = " " WHERE FORMNAME IS NULL
I get some invalid End-of-Staement error.
I've search high and low for the answer to no avail...
The reason for this is that I have brought SQL 7.0 Data over to the AS/400 DB2 database. The RPG program that needs to use this data just doesn't like to play nice with NULL values in fields.
If you have a solution to this, SQL for 7.0 is fine. I can translate into the SQL/400 format.... I think... (That's were it's actually going to run.)
Thank you,
Spencer Sullivan" |
|
|
|
|
|
SQL 7.0