Posted by orin on 04/12/06 18:18

Thanks Denis

yeah I just installed Query Analyser & ran my query through that & it
worked fine so it must be a limitation of the Delphi TQuery component.

Oh well.

I'll try a join as you suggested instead.

Thanks for your time
Jon

• Next in forum: Smalldatetime comparisons with non-clustered index
• Prev in forum: Re: SQL Server needs help from MS Access (or something)
• Thread view: Re: Are sub-subqueries possible?

[Reply to this message]