Ahmadal_najjar2003
asked on
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
I want to set null fields with empty txt
upsets student set homephene =''
where homephone = null
but not success
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ''
is there a command to set all fields in one table at once. so any field has null value set it to ''
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You
upsets student set homephene =''
where homephone IS null