Hello Vladan,

thx very much for your answer

it helped me a lot already

there is only one question i am having,

i did this with a left join because i was interested in...

SELECT substring(auxdata,

charindex('TAGmanager_nameTAG',auxdata),

(charindex('TAG/managerTAG',auxdata) - charindex('TAGmanager_nameTAG',auxdata)))

FROM workitem

where (id='53')

This thing gives me following result:

TAGmanager_nameTAG MR XXXX TAG/manager_nameTAG

But what i do need is just the info between the 2 tags here above

Thx

hi,

i have tried:

SELECT (substring(auxdata,charindex('',auxdata),

(charindex('',auxdata) - charindex('',auxdata)))

FROM workitem

but he gives me errors..

i just need a return value as a string