Re: SQL Replacement

Lawrence Watkins ( (no email) )
Tue, 5 May 1998 17:05:40 -0500

update subaccouts set accounttype="PPP" where
accounttype="PPa"

Would work I think.
Lar
-----Original Message-----
From: Michael Whisenant <mwhisen@airnet.net>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Tuesday, May 05, 1998 12:08 PM
Subject: SQL Replacement

>I am looking for a SQL statement that performs simple
replace. I would
>like to select records in a database that match a certain
criteria, and
>then change them to another string. This should be
straight forward, yet I
>have not found it in the SQL books. Anyone??
>Michael J. Whisenant
>Vice-President, Operations
>AIRnet Internet Services, Inc.
>ph: (256) 704-4692 fax: (256) 704-2329
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>