When I execute it returns 4 rows in the result set. Manually running the query in command line returns 3 rows. I have never experienced a situation where one query returned a different # of rows from the other.
Any explanation for this behavior or suggestions on how to determine cause.
[edited to add line breaks so screen doesn't scroll right] [ July 20, 2006: Message edited by: Jeanne Boyarsky ]