View previous topic :: View next topic
|
Author |
Message |
rupesh gullu
New User
Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon
|
|
|
|
Hi
I need to update one field in table but its giving error in syntax.
here is my code
update d9331cos.parcalc
set substr(homeid,4,4) = 'CO{{'
where hmo_id = '1223344'
Its giving error before ( in line 2
regards,
rupesh gupta |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you can't SET substr(column)
you have to SET column = substr(...) concatenate substr(....)
RTFM |
|
Back to top |
|
|
rupesh gullu
New User
Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon
|
|
|
|
Hi Dick,
Thanks it worked fine
regards,
rupesh gupta |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
rupesh gupta,
glad you were able to solve your problem. |
|
Back to top |
|
|
|