Results 1 to 2 of 2

Thread: count number of fields in a column

  1. Jun 1st, 2000, 08:11 AM #1
    Bebe
    Bebe is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    How could i make an output parameter that will count the number of rows that return a null value.

    I have rows and one of the columns vendor_id can return a null value. I need to count how many have a null value in the query i perform as an output parameter?


    Help!!!
    Reply With Quote Reply With Quote
  2. Jun 1st, 2000, 09:24 AM #2
    Chris
    Chris is offline
    PowerPoster Chris's Avatar
    Join Date
    Jan 1999
    Location
    K-PAX
    Posts
    3,238
    may be you need to scan through all the fields with the IsNULL function.
    My Virtual Home - My Blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width