Hi Many thanks for that. Ill give that a try in a bit and let you know how i get on.

Cheers

Steve

Hi Remi,

stored proc -

CREATE procedure usp_CheckMasschangeDatesAgainstBase

--- created by smr 08/06/2005

--- this query is used so that when a mass change done just to make sure no invoice beakdown already

(

@location as...

Hi Thanks for the reply...

did do this, i am starting to think the problem is with data format, and not the code. Are text and date a funny format soemtimes?

steve...