Thanks to both for your help. Will experiment and let you know the outcome.

Regards,

Attached...

I've just updated the statistics, and the query time is now down to 26 seconds.

I'm just reading that article you posted. For me, dynamic SQL has always been the root of all evil, however if it improves this sort of procedure I may re-write...

ImageURL just stores the file name of the image that is contained in the file system. It doesn't store any binary data.

I've modified the index to include: PropertyID, ImageURL, IsPrimary...

Thanks Christopher,

Execution plan is attached.

Regards,

Works perfectly, thanks.

Think this will go in a stored procedure rather than trying to figure out how to write this in LINQ...