Results 1 to 2 of 2

Thread: iif problem

  1. #1
    Join Date
    Apr 2004
    Posts
    9

    Unanswered: iif problem

    hi to all

    This is my first post to the forum

    whats the difference between

    iif(x=z;"*";cont)
    and
    like iif(x=z;"*";cont)

    apart from the fact that only the second statement will return all rows (if x is equal with z of course)

    thanks
    Nikolaidis Dimitris

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by mwiec
    hi to all

    This is my first post to the forum

    whats the difference between

    iif(x=z;"*";cont)
    and
    like iif(x=z;"*";cont)

    apart from the fact that only the second statement will return all rows (if x is equal with z of course)

    thanks
    Nikolaidis Dimitris
    Obviously the 2nd one is a pattern match ...

Posting Permissions

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