Hi,

If you are process a xml, and assume there are only record in it. I would prefer to use STREXTRACT to get the data between tag rather convert it into cursor.

OR another example is use strextract to get the check digit in your hkid. ie. XXXXXXX(X)