Declare XM_Cursor CURSOR FOR
SELECT XM,ID FROM JCXX WHERE XM LIKE '%(%'
OPEN XM_Cursor
FETCH FROM XM_Cursor into @XM,@ID
WHILE @@FETCH_STATUS=0
BEGIN
set @COUNT = PATINDEX( '%(%', @XM)
IF @COUNT > 0
BEGIN
SET @YXM = SUBSTRING(@XM,0,@COUNT)
UPDATE JCXX SET XM = @YXM WHERE ID = @ID
PRINT @YXM
END
FETCH NEXT FROM XM_Cursor into @XM,@ID
END
close XM_Cursor
DEALLOCATE XM_Cursor
