Change null values to zero in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings everyone! I have a query that gets the max field length number.
If the field is null, then there is no value. How do I update the null to a
zero? Below is the code.


SELECT Max(Len([fnm])) AS FNM1, Max(Len([lnm])) AS Lnm2 FROM uppercustomer;
 
SELECT Max(Len(Nz([fnm], ""))) AS FNM1, Max(Len(Nz([lnm], ""))) AS Lnm2 FROM
uppercustomer
 
thanks for the helpful post, it works like a charm!!!

Douglas J. Steele said:
SELECT Max(Len(Nz([fnm], ""))) AS FNM1, Max(Len(Nz([lnm], ""))) AS Lnm2 FROM
uppercustomer

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Ray Mead said:
Greetings everyone! I have a query that gets the max field length number.
If the field is null, then there is no value. How do I update the null to
a
zero? Below is the code.


SELECT Max(Len([fnm])) AS FNM1, Max(Len([lnm])) AS Lnm2 FROM
uppercustomer;
Click to expand...
Click to expand...
 
Back
Top