Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    111

    Unanswered: COALESCE on Where

    What is the right way of doing the following?

    Code:
    ...
    WHERE 
        COALESCE (recvDate1, recvDate2)
            BETWEEN '2007-07-01' AND '2008-06-30'
    thanks again!

  2. #2
    Join Date
    Jul 2006
    Posts
    111
    please cancel this question... the error was something else not the coalesce part... :-)

Posting Permissions

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