Thanks for the quick response, it's obvious when you think about it, I obviously wasn't thinking 🙂

Thanks for the responses guys, I'll give 'em a go

I'm not particularly interested in the transaction logs anyway as I will always have the source data files to reload from if anything goes wrong, so is there any way...

Gail

Will do, thanks for the tip, don't want to get into bad habits this early

'Simple' is best

Roland,

That worked a treat, many thanks, I was obviously over complicating things

Many thanks for your response, I'll give it a go and let you know how I get on

You're right, I'll do that

I'll create new indexes in the source file

I used a CASE clause and it seems to be working

WHEREHOrder.Acno = CASE LTRIM(RTRIM(@Acno))

WHEN '' THEN HOrder.Acno

ELSE @Acno

END

AND

SUBSTRING(HDespatch.ArcOrdno,1,4)=CASE LTRIM(RTRIM(@Unit))

WHEN '' THEN SUBSTRING(HDespatch.ArcOrdno,1,4)

ELSE @Unit

END

AND

SUBSTRING(HDespatch.ArcOrdno,5,8)>=CASE LTRIM(RTRIM(@Fdate))

WHEN '' THEN...

Thanks, I'll have a look at both