| Fill a field with an alpha plus the info from another field [message #381] |
Fri, 08 February 2002 09:58  |
CHRISTA S. WILLIAMS
Messages: 3
Registered: February 2002
|
Junior Member |
|
|
In my table, CUST, I have a field zone_cd that is by and large a null value. I need it to have the letter Z and the contents of the field srt_cd. What I tried is this.Please correct me where I am making the mistake. Thank you.
---------------------------------------
update cust
set zone_cd = 'Z' + srt_cd
where srt_cd is not null
and zone_cd is null
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
