Function to find non-printable characters

CREATE FUNCTION dbo.HasNonPrintableChar (@input_string VARCHAR(MAX))
/* =============================================
-- Author:Damien Alvarado
-- Create date: 2009-04-22
-- Email: damien.alvarado at parivedasolutions dot com
-- Description :The function checks the input string for non-printable characters like TAB, LF, BS and returns 1 if any are found, 0 otherwise

--Input parameters  @input_string VARCHAR(MAX), the string to search
--Output parameters :
--Return value : 0 --> No non-printable characters were found
                 1 --> Non-printable characters were found


 =============================================*/RETURNS INTEGER
AS 
BEGIN
DECLARE @i INTEGER
DECLARE @string_length INTEGER
DECLARE @found_non_printable_character INTEGER
DECLARE @ascii_value INTEGER

SET @i = 1
SET @string_length = LEN(@input_string)
SET @found_non_printable_character = 0

--Check each character in the string for non-printable characters
WHILE @i <= @string_length AND @found_non_printable_character = 0
BEGIN
    SET @ascii_value = ASCII(SUBSTRING(@input_string,@i,1))

    --The range of printable ASCII characters is between 32 and 126
    IF  @ascii_value < 32 OR @ascii_value > 126 
    BEGIN
        SET @found_non_printable_character = 1
    END

    SET @i = @i + 1
END

RETURN @found_non_printable_character

END