I'm trying to write a sql statement to update a numeric field in tstmis/actfile, but I'm running into a problem with null

Null values not allowed in column or variable UMNUM
.
Below is the query

update tstmis/actfile a
set umnum = (select substring(digits(umnum),6,4)
from tstmis/shactfile b where a.umact = b.umact and b.umnum > 0 and
a.umnum = 0 )

I think the problem is when I have a value like 123450000 which creates a substring of 0000

Any idea how to get around this?

Thanks

Mike

NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].