Re: How to update the record based on certain criterias.

R Chin wrote:

> Hey Daniel, didn't you post a message few days ago about you being a teacher
> and that if you ever catcha student posting HW questions....blah blah....
>
> Errr..somehow I got the feeling this is the type of question a student'd
> asks....
> (nothing against you, kpn)
>
> robert
>
> Daniel Morgan wrote in message <3D29B6EC.2CA000D1_at_exesolutions.com>...
> >You use an WHERE clause on the update statement in the form:
> >
> >UPDATE table_name
> >SET field_name = some_thing
> >WHERE field_name = some_value;
> >
> >To append a prefix look up CONCATENATION in your book.
> >
> >Daniel Morgan
> >

I agree. Which is why my answer is a hint rather than the working code. And why the statement "look up ... in your book".

100% student in my estimation.

Daniel Morgan Received on Wed Jul 10 2002 - 13:11:41 CDT