Sorry, missed out the filename :-(
Posted in 1992
I write : > How about (from the command line in sh or csh) > > sed 's/.*/delete from tab_1 where my_key = "&";/' | isql db_name ^ | | Ooops, your keys filename has to go in here, unless you want to type all the keys in ! Suppose you might have to clip off whitespace, too - try something like sed -e 's/ *//' -e 's/.*/delete from tab_1 where my_key = "&";/' foo | \\ isql db_name if so. Sorry, red-faced smiley ... Cheers - Tony. __________________________________________________________________________ Tony Heskett th@bnr.co.uk Voice: (+44) 279 429531 x 2637 BNR, London Road, Harlow, Essex, CM17 9NA Fax: (+44) 279 454187