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_at_reader1.panix.com>
Date: Tue, 9 Jul 2002 18:26:04 -0400
Message-ID: <agfntu$cdf$2_at_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....
robert
Daniel Morgan wrote in message <3D29B6EC.2CA000D1_at_exesolutions.com>...
(nothing against you, kpn)
>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 Wed Jul 10 2002 - 00:26:04 CEST