On Wed, Jan 08, 2003 at 09:02:47 -0500, "Randy D. McCracken" <[EMAIL PROTECTED]> wrote: > > UPDATE publications SET url = 'www.srs.fs.usda.gov' WHERE url = > 'www.srs.fs.fed.us';
For simple cases you can do this with available string functions. For more complicated cases, you can write a simple application that selects records (which means you will need a unique key returned) based on a regular expression and then the application will issue updates for the matching records. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly