Thanks alot. i can use either 'Stop' or 'stop'. It's not case sensitive am i correct? Thanks, Rams. Thu, 13 Aug 2009 00:56:21 -0700 On 13/8/09 08:41, Michael Bryant wrote:

Wrong operator. Use = or not := --Mike

It's a comparison so it should be: if (Acct-Status-Type == 'stop') { sql } Steve -- Steven Carr Systems Development Officer SLS/ITS/Systems - (0191) 515 3953