Topic
2 replies Latest Post - ‏2006-08-31T05:18:00Z by SystemAdmin
SystemAdmin
SystemAdmin
3105 Posts
ACCEPTED ANSWER

Pinned topic UPDATE SET SUBSTR ?????

‏2006-08-28T13:58:41Z |
Hi every body.

It is possible to make use of the SUBSTR, within clause UPDATE?

Particularly I believe that it is not possible, somebody will know here if it is it?

It tries it, but it gives error me -104.

Thank's.

Fernando.
Updated on 2006-08-31T05:18:00Z at 2006-08-31T05:18:00Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    3105 Posts
    ACCEPTED ANSWER

    Re: UPDATE SET SUBSTR ?????

    ‏2006-08-29T08:37:10Z  in response to SystemAdmin
    If you want update SUBSTR(cola,4,3), how about this way?
    code
    UPDATE Table
    SET cola = SUBSTR(cola,1,3) || <new_data> || SUBSTR(cola,7)
    WHERE ...[/code]
    • SystemAdmin
      SystemAdmin
      3105 Posts
      ACCEPTED ANSWER

      Re: UPDATE SET SUBSTR ?????

      ‏2006-08-31T05:18:00Z  in response to SystemAdmin
      Just to make more clearer...
      SUBSTR clause cannot be used on left side of '= ' operator in SET statement...It can be used only with operand on right side.