Z zyus Aug 27, 2008 #1 I hv this NPLFLG field with Y, N and null. How to replace null to N in update query Thanx
J John W. Vinson Aug 27, 2008 #3 I hv this NPLFLG field with Y, N and null. How to replace null to N in update query Thanx Click to expand... Use a criterion of IS NULL and update to "N". The IS NULL syntax is specific - NULL won't work, "NULL" won't work.
I hv this NPLFLG field with Y, N and null. How to replace null to N in update query Thanx Click to expand... Use a criterion of IS NULL and update to "N". The IS NULL syntax is specific - NULL won't work, "NULL" won't work.
