Guest User

Untitled

a guest
Jan 22nd, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. DECLARE @a as NVARCHAR(15)
  2. SET @a = '2.18.4.14'
  3.  
  4. SELECT
  5. @a = CASE
  6. WHEN CHARINDEX('.',@a) < 4
  7. THEN STUFF(@a,1,0,REPLICATE('0',4-CHARINDEX('.',@a,1)))
  8. ELSE @a
  9. END
  10. ,
  11. @a = CASE
  12. WHEN CHARINDEX('.',@a) < 8
  13. THEN STUFF(@a,5,0,REPLICATE('0',8-CHARINDEX('.',@a, 5)))
  14. ELSE @a
  15. END
  16. ,
  17. @a = CASE
  18. WHEN CHARINDEX('.',@a) < 12
  19. THEN STUFF(@a,9,0,REPLICATE('0',12-CHARINDEX('.',@a, 9)))
  20. ELSE @a
  21. END
  22. ,
  23. @a = CASE
  24. WHEN LEN(@a) < 15
  25. THEN STUFF(@a,13,0,REPLICATE('0',15-LEN(@a)))
  26. ELSE @a
  27. END
  28.  
  29. SELECT @a
Add Comment
Please, Sign In to add comment