Back to OIM Explorer

dbo.QBM_FCVStringToDigits

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 410 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL28 lines
1CREATE FUNCTION dbo.QBM_FCVStringToDigits(2  @in nvarchar(1000)3) RETURNS varchar(10004)5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @erg varchar(1000) = ''9  DECLARE @zeichen nvarchar(1)10  DECLARE @l int = len(@in)11  DECLARE @i int = 112  WHILE @i <= @l13  BEGIN14    SELECT15      @zeichen = SUBSTRING(@in,16      @i,17      1)18    IF @zeichen LIKE '[0-9]'19    BEGIN20      SELECT21        @erg = CONCAT(@erg,22        @zeichen)23    END24    SELECT @i += 125  END26  endLabel:27  RETURN(@erg)28END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QBM_FCVStringToDigits(@in nvarchar(1000) ) returns varchar(1000) with SCHEMABINDING as begin declare @erg varchar(1000)2 = '' declare @zeichen nvarchar(1) declare @l int = len(@in) declare @i int = 1 while @i <= @l begin select @zeichen = SUBSTRING(@in, @i, 1) if @zeichen3 like '[0-9]' begin select @erg = concat(@erg , @zeichen) end select @i += 1 end endLabel: return(@erg) end 4