Re: update email address

HansF (News.Hans_at_telus.net) wrote:
: On Tue, 05 Apr 2005 13:55:02 -0700, Sheela interested us by writing:

: > update student a set
: > substr(a.email_addr,(instr(a.email_addr,'@')+1),10) = 'yyyyy.com'where

: Basically the SET clause requires a column on the left side immediately
: after the 'set', but you seem to have a wild expression in place of the
: column name.  (Nor does your statement meet any of the other variations
: permitted.)

It looks like valid perl to update a portion of a string. I suspect the poster has "losing track of multiple contexts" syndrome.

--

This space not for rent.