Oh, and it's a PostgreSQL database. I switched back because the 10GB 
restriction on SQL Server Express was a deal breaker as the Address 
Database was over 12GB when loaded and indexed. I found an ADO .NET 
driver for PostgreSQL and it works exactly like the SQL Server .NET 
connection. I'm actually starting to like Visual Studio .NET. Paradox is 
a lot easier in so many ways, but when using graphics and modern UI 
techniques Paradox is showing its age and obsolescence.

Oh, and Larry, I can use PostgreSQL on Azure. ;-)

On 20/06/2016 11:54 AM, Tom Krieg wrote:
> I joined a couple of fields into a single index and tried your
> suggestion below, and got the query down to 860ms which is more than
> acceptable. Thanks Liz.
>