Set null fields with empty text

Salam

I want to set null fields with empty txt

upsets student set homephene =''
where homephone = null

but not success
Ahmadal_najjar2003Asked:
Who is Participating?
 
Richard LeeConnect With a Mentor Software EnthusiastCommented:
Try:

Update Student
     Set homePhene = ''
   Where homePhene IS NULL

DaTribe
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:

upsets student set homephene =''
where homephone IS null
0
 
Ahmadal_najjar2003Author Commented:
Thats work fine , I have a nother question
is there a command to set all fields in one table at once. so any field has null value set it to ''
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
not, there is no such command. you have to specify each field individually for such a UPDATE statement
0
 
Ahmadal_najjar2003Author Commented:
Thank You
0
All Courses

From novice to tech pro — start learning today.