How do I replace null values in columns?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

update master set document = '' where document is null

Andy

padmakumar_pga Right there with Babe Points: 766 More actions · Answer 2

u can use update statement .

update Table set column=value where column is null

if u r adding a new column in an existing table u can avoid null using with value

Alter Table TableName

Add column Datatype Default(value) with Values