Replace Null In Text Field

[zyus]

I hv this NPLFLG field with Y, N and null.

How to replace null to N in update query

Thanx

 

[JvC]

Use is null as the criteria.

zyus explained on 8/26/2008 :

 

[John W. Vinson]

I hv this NPLFLG field with Y, N and null.

How to replace null to N in update query

Thanx

Use a criterion of

IS NULL

and update to "N".

The IS NULL syntax is specific - NULL won't work, "NULL" won't work.