Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    6

    Unanswered: iif() inside INSERT INTO statement

    Hi Everybody,

    Just want to ask your help if you have an idea or example of code on how Iam going to write an INSERT INTO statement that will returns a null value.

    Ex. if (call_duration IS NULL) then
    field = "00:00:00"
    else
    field = call_duration
    endif

    Please I really need your help.

    Thank you.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    How about

    Nz(call_duration, "00:00:00")

    you might just want a zero, depending on the data type of the target field.
    Paul

Posting Permissions

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