How can I update a table for only records that have a blank value?

[jazzyjj]

In other words, I need to skip all records that have a value. In this case, I will only be updating accounts 85 and 92...PLEASE HELP!!

Table - pat

acct group
2 2365
253 66995
41 nkj1236
85
92

 

[SQLScholar]

Depends if the entry is blank - or null. But one of the below....


BLANK

UPDATE
Tablename
SET
[acct group] = VALUEHERE
WHERE
[acct group] is null

NULL

UPDATE
Tablename
SET
[acct group] = VALUEHERE
WHERE
[acct group] is null

Obviously fill in Tablename and VALUEHERE with what you want to update it to.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[bborissov]

[tt]
acct group
--------------
2 2365
253 66995
41 nkj1236
85
92
[/tt]

UPDATE Table SET Group = 'SomeValue' WHERE ISNULL(Group,'') = ''

Borislav Borissov
VFP9 SP2, SQL Server