UPDATE recruit SET A_1 = '00' WHERE A_1 FAILS

If A_1 is a INTEGER, then remove the quotes.


Jeff Richardson | Project Manager, Asset Verification Services (AVS)
DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, 
Fort Wayne, IN 46802
Cell: 724-366-1724
Connect: jrichard...@dmainc.com | Website | LinkedIn | Twitter | Facebook
___________________________________________________________
ATTENTION: This message and all attachments are PRIVATE, and may contain 
information that is CONFIDENTIAL and PRIVILEGED.  If you have received this 
message in error, please notify the sender by reply e-mail and delete the 
message immediately.

-----Original Message-----
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bishop CIV Denise K
Sent: Friday, September 16, 2016 5:36 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - how do you change a null value in the database

This is one of the  command I used before I converted from 6 to 9.5

CHA A_1 TO 00 IN RECRUIT WHE A_1 FAI

I don't know the new command that will change a null value to a number

Denise Bishop

Information Technology Specialist
A+ Certified, Security+ Certified
MCCS South Carolina
843-228-1509
email: bish...@usmc-mccs.org

'You do not have because you do not ask God.'
Have you prayed and asked God to open up some new doors or possibilities for 
you?

β€œFor official use only – privacy sensitive (FOUO).
Any misuse or unauthorized access may result in both civil and criminal 
penalties.”


--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
ATTENTION: This message and all attachments are PRIVATE, and may contain 
information that is CONFIDENTIAL and PRIVILEGED. If you have received this 
message in error, please notify the sender by reply e-mail and delete the 
message immediately.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to