CREATE FUNCTION dbo.IsAlphaNumeric2(
	@input VARCHAR(MAX)
)
RETURNS BIT
AS
BEGIN
	DECLARE @result BIT = 1 -- default result to true
	IF (@input LIKE '%[^a-Z,0-9,'' '']%')
	BEGIN	
		SET @result = 0 -- found a non-alphanumeric character
	END

	RETURN @result -- return result
END

CREATE FUNCTION dbo.IsAlphaNumeric3(
	@input VARCHAR(MAX)
)
RETURNS BIT
AS
BEGIN
	DECLARE @result BIT = 1 -- default result to true
	IF (PATINDEX('%[^a-Z,0-9,'' '']%', @input) > 0)
	BEGIN	
		SET @result = 0 -- found a non-alphanumeric character
	END

	RETURN @result -- return result
END