nulls and zeros

Results 1 to 2 of 2

Thread: nulls and zeros

  1. #1
    nomit Guest

    Default nulls and zeros

    Hello<BR><BR>I have SQL that returns the sum of a field. When there are no entries it returns a null. In access you can use NZ (NVL in Oracle) to force a zero to be returned. How do you do this is with ASP? I get a message : NZ is considered undefined<BR><BR>Cheers<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: nulls and zeros

    Use ISNULL(exp, value) instead - the first argument is the expression which may have a NULL value, the second is the value to replace the NULL with.<BR><BR>Dunc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts