I've written the following script:
This works fine on a single record where docid = 'RD00000017' but i can't get this to loop through the table. I'm still searching the forums and faqs. Any suggestions?
Thank you in advance.
"The only desert to an Irishman is an empty glass".
Code:
DECLARE @PtrVar BINARY(16)
DECLARE @InsertPos INT
DECLARE @DeleteLen INT
select @PtrVar = TEXTPTR(issues),
@InsertPos = (PATINDEX('%Likelihood mark%', issues) -1),
@DeleteLen = (
(PATINDEX('%mark%', issues) + 4) - PATINDEX('%Likelihood%', issues)
)
from [sltds_c32_e-table])
[b]where docid = 'RD00000017'[/b]
BEGIN
UPDATETEXT [sltds_c32_e-table].issues
@PtrVar
@InsertPos
@DeleteLen
with Log
'LOC [Strength of Mark]'
END
This works fine on a single record where docid = 'RD00000017' but i can't get this to loop through the table. I'm still searching the forums and faqs. Any suggestions?
Thank you in advance.
"The only desert to an Irishman is an empty glass".