Back to OIM Explorer

dbo.QBM_FCVStringTrimLeft

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 821 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

SQL45 lines
1CREATE FUNCTION dbo.QBM_FCVStringTrimLeft(2  @In nvarchar(max),3  @TrimChars nvarchar(64),4  @CaseSensitive BIT = 05) RETURNS nvarchar(max6)7  WITH SCHEMABINDING8AS9BEGIN10  DECLARE @erg nvarchar(max)11  DECLARE @TrimChars_intern nvarchar(100)12  SELECT13    @trimchars_intern = isnull(@TrimChars,14    N '')15  SELECT @trimchars_intern = N '%' + @trimchars_intern + N '%'16  SELECT17    @erg = isnull(@in,18    N '')19  IF @CaseSensitive = 120  BEGIN21    WHILE len(@erg) > 0 AND @trimchars_intern LIKE N '%' + substring(@erg,22    1,23    1) + N '%' collate SQL_Latin1_General_CP1_CS_AS24    BEGIN25      SELECT26        @erg = substring(@erg,27        2,28        len(@erg) -1)29    END30  END31  ELSE32  BEGIN33    WHILE len(@erg) > 0 AND @trimchars_intern LIKE N '%' + substring(@erg,34    1,35    1) + N '%' collate SQL_Latin1_General_CP1_CI_AS36    BEGIN37      SELECT38        @erg = substring(@erg,39        2,40        len(@erg) -1)41    END42  END43  ende:44  RETURN(@erg)45END
Open raw exported source
SQL ยท Raw7 lines
1  create   function dbo.QBM_FCVStringTrimLeft ( @In nvarchar(max) , @TrimChars nvarchar(64) , @CaseSensitive bit = 0 ) returns nvarchar(max) with2 SCHEMABINDING as begin declare @erg nvarchar(max)  declare @TrimChars_intern nvarchar(100) select @trimchars_intern = isnull(@TrimChars, N'')    select3 @trimchars_intern = N'%' + @trimchars_intern + N'%' select @erg = isnull(@in, N'') if @CaseSensitive = 1 begin while len(@erg) > 0 and @trimchars_intern4 like N'%' + substring(@erg, 1, 1) + N'%' collate SQL_Latin1_General_CP1_CS_AS  begin select @erg = substring(@erg, 2, len(@erg) -1 ) end end else begin5 while len(@erg) > 0 and @trimchars_intern like N'%' + substring(@erg, 1, 1) + N'%' collate SQL_Latin1_General_CP1_CI_AS  begin select @erg = substring6(@erg, 2, len(@erg) -1 ) end end ende: return(@erg) end 7