get real! : SQL split 함수

thanks to;

http://blog.naver.com/hukim79?Redirect=Log&logNo=60140217656

ALTER FUNCTION [dbo].[UF_TEXT_SPLIT_STRING]
(
    -- Add the parameters for the function here
    @TEXT       VARCHAR(1000)
    ,@DELIMITER CHAR(1)
,@postion INT
) RETURNS VARCHAR(100)
AS
BEGIN
-- Declare the return variable here
DECLARE @INDEX INT
DECLARE @STRINGS VARCHAR(100)
DECLARE @RET_STRINGS VARCHAR(100)
DECLARE @cnt INT

-- Add the T-SQL statements to compute the return value here
SET @INDEX = -1

SET @cnt = 1

WHILE (LEN(@text) > 0)
BEGIN
  SET @INDEX = CHARINDEX(@DELIMITER , @TEXT)

  IF (@INDEX = 0) AND (LEN(@TEXT) > 0)
  BEGIN
   set @STRINGS = @TEXT
   IF @cnt = @postion
   BEGIN
    SET @RET_STRINGS = @STRINGS
    BREAK
   END
   BREAK
  END

  IF (@INDEX > 1)
  BEGIN
   set @STRINGS = LEFT(@TEXT, @INDEX - 1)
   IF @cnt = @postion
   BEGIN
    SET @RET_STRINGS = @STRINGS
    BREAK
   END
   SET @TEXT = RIGHT(@TEXT, (LEN(@TEXT) - @INDEX))
  END
  ELSE
   SET @TEXT = RIGHT(@TEXT, (LEN(@TEXT) - @INDEX))