Results 1 to 2 of 2

Thread: ASP and SQL

  1. #1
    susheil kumar Guest

    Default ASP and SQL

    I would like to retrieve all the rows from a table for which firstname field is null. I would like to use an SQL query for this which doesnt use the Isnull function!!!!. Its possible, but i dont have the answer. can any one help me out on this. Thanx in advance<BR><BR>-susheil

  2. #2
    SPG Guest

    Default RE: ASP and SQL

    "select * from myTable where FirstName IS NULL" is the SQL-92 way of doing it.

Posting Permissions

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