Posts by André Luiz • 31 points

• 3

  votes

  3

  answers

  189

  views

  A: LEN function, know number of characters of a number

  First create the function CREATE FUNCTION dbo.countDigits(@A float) RETURNS tinyint AS BEGIN declare @R tinyint IF @A IS NULL RETURN NULL set @R = 0 while @A - str(@A, 18 + @R, @r) <> 0 begin…

  sql sql-server function

  answered 6 years, 4 months ago André Luiz 31