SELECT dbo.regexReplace(yourfield, '[\x00-\x1f]', '', 1, 1 ) FROM yourtable;
DECLARE @regex integer;
SET @regex = dbo.regexObj( '[^a-z]', 1, 1 );
SELECT dbo.regexObjReplace( @regex, firstname, '' ) FROM account;
DECLARE @regex integer;
SET @regex = dbo.regexObj( '[\x00-\x1f]', 1, 1 );
SELECT dbo.regexObjReplace( @regex, firstname, '' ) FROM account;
Kindly explain more on this with examples to help you better..