You are a star 🙂

Thank you very much

Many thanks for that, will give it a bash 🙂

yep I just found realised that LAG is not used in SQL 2k8 🙁

any other ideas of how to easily achieve this??

I basically want to say :

CASE

...

No worries,

I think I found it......LAG function should do the trick. Will test.

Ah brilliant, much appreciated 🙂

Hi Chris,

ok i'm gonna go back to the beginning.

the contents of the text field in the db (USERTYPES1) is the following and I need to extract everything after...

Hi Chris,

I tried using the code you gave but still no joy!

Any other ideas?

Thanks Chris, I'll take a look at that. much appreciated.

You can see why i'm tearing my hair out now lol!

Looking at what I've posted, it just looks very messy.

in a bid t simplify it:

this hardcoded string works:

'NCA~Non-Current Assets CA~Current Assets PAY~Creditors: amounts falling due within one...

Hi Chris,

my code is as below (this is the one that works - with the info hardcoded): If you look at lines 10 and 11 you'll see the...

Hi,

I've tried casting and converting to varchar(max), but still no joy!