Set field = NULL

[dbomrrsm]

Hi All

I need to set a field to NULL in a table before I do an update - any ideas on a quick method as the below takes ages.

Update MyTable
Set MyField = NULL

Cheers

DBomrrsm

 

[hymn]

What do you mean by null?
0 or ""
Is it text or numeric

Hope this helps
Hymn

 

[dbomrrsm]

NULL as in if I did a

Count (*)
FROM MyTable
WHERE MyField IS NOT NULL

I would get zero

 

[hymn]

try an update query

Hope this helps
Hymn

 

[dbomrrsm]

Thats what I did try - but thanks for your help anyway

 

[hymn]

Yes! I will have to looking at what forum I'm connecting to, it looks as though something has wobbled on my machine

Hope this helps
Hymn

 

[dcpking]

It sounds like you have the field indexed, which may be the cause of the slow response (multiple things happening per row updated).

A standard procedure is to remove indices, apply update, and re-impose indices.

hth

Mike

 

[dbomrrsm]

Mike

Your right - thanks for the tip which I should have known.

Cheers

DBomrrsm