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

From: R Chin <rchin_at_panix.com>
Date: Tue, 9 Jul 2002 18:26:04 -0400
Message-ID: <agfntu$cdf$2@reader1.panix.com>

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
>
Received on Tue Jul 09 2002 - 17:26:04 CDT