>IF EXISTS (SELECT * > FROM sysobjects > WHERE name = N'ufn_ValidateSSN') > DROP FUNCTION ufn_ValidateSSN >GO > >CREATE FUNCTION ufn_ValidateSSN > (@SSN char(11)) >RETURNS int >AS >BEGIN > DECLARE @Ret int, @i int > SET @I = 1 > WHILE @I <= LEN(@SSN) > BEGIN > IF @I IN (4, 7) > BEGIN IF SUBSTRING(@SSN, @I,1) <> '-' BREAK END > ELSE > IF NOT (SUBSTRING(@SSN, @I,1) BETWEEN '0' AND '9') BREAK > SET @I = @i + 1 > END > > RETURN CASE WHEN @I <= LEN(@SSN) THEN 0 ELSE 1 END >END >>>I need to write a UDF to validate existing SSN in our system. We have found numerous SSN's with a character in the number. The numbers were imported from another system that did not validate the information.