I tried declare and having clause both worked. My syntax for having which I tried yesterday was incorrect.

I am now verifying data results to ensure I am fetching...

Thank you. Very Helpful.

This worked. Thank YOu.

Actually no error message displayed. The function called from stored procedure was not fetching data from database to display on page for end user-this was only occurring for dates stored...

thank you. will try this and see if it works. Thanks

Tina