주민번호체크함수
-
MS-SQL 주민번호 체크 쿼리프로그램/Mssql 2024. 1. 23. 11:49
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[uf_jNo_Check](@number char(13)) RETURNS char(13) BEGIN --Set Nocount on DECLARE @returnValue as char(1), @value int SELECT @returnValue='0' IF @number NOT LIKE '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]' RETURN @returnValue SELECT @value=0 SELECT @value=@value+substring(@number,1,1)*2 SELECT @value=@value..