RE: SQL Replacement

Michael Whisenant ( )
Tue, 05 May 1998 17:09:39 -0500

Well I found the Update statement. Lets say for example I wanted to replace
all the entries in the Table SubAccounts the field is LoginLimit where
LoginLimit=0 I wanted to change it to LoginLimit=1. There is something
about update in place. Any ideas on the script to run.
Here is one sample,
anyone know if this will do what I anticipate?

UPDATE SubAccount
LoginLimit = '1'
WHERE LoginLimit = '0'

Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329