1 2 3 4 5 6 7 8 9 10 11 12 |
-- ************ 처리 set @lenCARDNUMBER = Len(@CARDNUMBER) if @lenCARDNUMBER>4 Begin Set @CARDNUMBER = stuff(@CARDNUMBER, 1, @lenCARDNUMBER-4 , replicate('*',@lenCARDNUMBER-4)) Set @CARDVALIDATE = '**/**' end -- 출력 : ************6666 |