quote:
can't use cursor because can't declare variable as text
If the table has a PK then you could retrieve the PKs once and use a cursor to loop thru them and then action the select (using the PK instead of patindex) and updatetext.
Far away is close at hand in the images of elsewhere.
Anon.