Stored procedure to change existing data

[2969]

hi,

I have a table that has defaults defined for each column. How can i change the existing data in this table to be set as default where NULLs are present. Actually I just managed to set-up defaults for each column so any new data will be correct, now the question is to how to take care of the already exisitng data. Is there any stored procedure I can run.

 

[Mike Lewis]

2969,

Sounds like this is one-off job, right? If so, why bother with a stored procedure. You only need a single line of code, something like this:

USE MyTable
REPLACE MyField with MyDefaultValue FOR ISNULL(MyField)

(OK, that's two lines, but still ... )

Does that answer your question?

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com