Null Values

Results 1 to 2 of 2

Thread: Null Values

  1. #1
    Join Date
    Dec 1969

    Default Null Values

    Hi..<BR> Want to fire a query to count no. of records in sql 7.0 where a column name price is blank or does not have any value..

  2. #2
    Join Date
    Dec 1969

    Default RE: Null Values

    SELECT COUNT(*) FROM TheTable<BR>WHERE Price IS NULL OR Price = &#039;&#039;<BR><BR>

Posting Permissions

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