Returning values with ISNULL

Results 1 to 3 of 3

Thread: Returning values with ISNULL

  1. #1
    James P. Guest

    Default Returning values with ISNULL

    I am using a select statement similar to the following:<BR>SELECT ISNULL(name,&#039No name given&#039) from TableA.<BR><BR>Later in my code, I want to reference name like such:<BR>Foo = rs("name")<BR>However, I get an error. How can I reference name?<BR><BR>Thanks for any help.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Returning values with ISNULL

    SELECT ISNULL(name,&#039No name given&#039) whatevername from TableA.<BR><BR>then in your code<BR><BR>recordset("whatevername")<BR>

  3. #3
    James P. Guest

    Default Thanks Akhilesh! -eom


Posting Permissions

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