Adrian, I believe the correct syntax for what you're trying to achieve would be : select 'update node ' || node_name || 'password' from nodes. Off course you'll have to send the output of the select in a script or a macro to achieve your goal ! Hope this helped ... Cheers
Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Mazarache Sent: Wednesday, 18 August, 2004 08:46 To: [EMAIL PROTECTED] Subject: updating multiple nodes Hello list! Can anyone help with some tricky hints about updating multiple nodes? something like update node (select node_name from nodes) password Any help is appreciated.