-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Chuck,
If you need to change NULLs to a value all you need do is: UPDATE table_name SET field_name = 'your_value' WHERE field_name IS NULL; HTH, Bryant Hester - -----Original Message----- From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Null to a value... Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support - --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPXuqlUlWu7/HFp4nEQLU+QCfUCU6cSEmIdmU9TdXs+gSd5RaSjcAn2ri 3c5Mom7FPV/gxGUQnOwuXrqb =tUOk -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
