dbo.QER_FGIExtendedAttributMatch

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:59:27.197 · modified 2026-04-14T23:20:36.143 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	int	yes
`@Search`	nvarchar	no
`@LowerLimit`	nvarchar	no
`@UpperLimit`	nvarchar	no

Referenced objects

Schema	Object	Column/minor	Class
No SQL expression dependencies in snapshot.

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1                                          create   function dbo.QER_FGIExtendedAttributMatch (@Search nvarchar(64),  @LowerLimit nvarchar(64),  
2@UpperLimit nvarchar(64)  ) returns int with SCHEMABINDING as begin declare @erg int select @erg = 0  declare @SearchWildCard bit  select @SearchWildCard
3 = 0 declare @LowerLimitWildCard bit  select @LowerLimitWildCard = 0 declare @UpperLimitWildCard bit  select @UpperLimitWildCard = 0 declare @MinCmp int
4  declare @CmpSearch nvarchar(64) declare @CmpLowerLimit nvarchar(64) declare @CmpUpperLimit nvarchar(64) declare @LenSearch int declare @LenUpperLimit
5 int declare @LenLowerLimit int if isnull(@search , N'') like N'%*' begin select @SearchWildCard = 1 select @CmpSearch = left(@search, len(@search) -1 
6) end else begin select @CmpSearch = isnull(@Search, N'') end select @LenSearch = len(@CmpSearch) if @Search = N'*' begin select @erg = 1  return(@erg)
7  end if isnull(@Search,N'') = '' begin  return(@erg)  end if isnull(@LowerLimit , N'') like N'%*' begin select @LowerLimitWildCard = 1 select @CmpLowerLimit
8 = left(@LowerLimit, len(@LowerLimit) -1 ) end else begin select @CmpLowerLimit = isnull(@LowerLimit, N'') end select @LenLowerLimit = len(@CmpLowerLimit
9) if isnull(@UpperLimit , N'') like N'%*' begin select @UpperLimitWildCard = 1 select @CmpUpperLimit = left(@UpperLimit, len(@UpperLimit) -1 ) end else
10 begin select @CmpUpperLimit = isnull(@UpperLimit, N'') end select @LenUpperLimit = len(@CmpUpperLimit)  if  @lenUpperLimit > 0 and @LenLowerLimit = 0 
11 or @LowerLimitWildCard = 0 and @UpperLimitWildCard = 1  or ( @LenUpperLimit > 0 and (  @LowerLimitWildCard = 1 and @UpperLimitWildCard = 1 and @LenUpperLimit
12 <> @LenLowerLimit  or @LowerLimitWildCard = 0 and @UpperLimitWildCard = 0 and @LenUpperLimit <> @LenLowerLimit  or @LowerLimitWildCard = 1 and @UpperLimitWildCard
13 = 0 and @LenUpperLimit < @LenLowerLimit ) ) or @LowerLimit like N'%*_%'  or @UpperLimit like N'%*_%'  or @Search like N'%*_%'  begin   return(@erg)  end
14 if @LowerLimitWildCard = 0 begin if @LenSearch > @LenLowerLimit  begin  return(@erg)  end select @MinCmp = @LenLowerLimit end else begin select @mincmp
15 = @LenSearch if @LenLowerLimit < @mincmp begin select @MinCmp = @LenLowerLimit end end if @SearchWildCard = 0 begin if @LowerLimitWildCard = 0 begin  
16 if @lenSearch > @LenLowerLimit begin  return(@erg)  end  if @LenUpperLimit = 0 begin if @CmpSearch = @CmpLowerLimit begin select @erg = 1 end  return(@erg
17)  end  if @CmpLowerLimit <= @CmpSearch and @CmpSearch <= @CmpUpperLimit begin select @erg = 1 end end else  begin  if @lenUpperLimit = 0 begin if @CmpLowerLimit
18 = left(@CmpSearch, @LenLowerLimit) begin select @erg = 1 end end else begin  if @UpperLimitWildCard = 1 begin if left(@CmpSearch, @LenUpperLimit) <= @CmpUpperLimit
19 begin select @Erg = 1 end end else begin  if @cmpSearch <= @CmpUpperLimit begin select @erg = 1 end end end end  end else  begin if @LowerLimitWildCard
20 = 0 begin   if @LenUpperLimit = 0 begin if @CmpSearch = left(@CmpLowerLimit, @LenSearch) begin select @erg = 1  return(@erg)  end end if  left(@CmpLowerLimit
21, @LenSearch) <= @CmpSearch and @CmpSearch <= left(@CmpUpperLimit, @LenSearch) begin select @erg = 1 end end else  begin  if @lenUpperLimit = 0  begin 
22if left(@CmpLowerLimit, @mincmp) = left(@cmpSearch, @mincmp) begin select @erg = 1 end end else begin  if left(@CmpLowerLimit, @mincmp) <= left(@cmpSearch
23, @mincmp) begin if @UpperLimitWildCard = 1 begin if left(@cmpSearch, @mincmp) <= left(@CmpUpperLimit, @mincmp) begin select @erg = 1 end end else begin
24 if @cmpSearch <= left(@CmpUpperLimit, @LenSearch) begin select @erg = 1 end end end end end  end  endLabel: return(@erg) end 
25

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:36.143

None extracted.

Summary: No calls/DML/dependency patterns extracted by the current parser.

Declared parameters

Parameter	Type	Direction
	`int`	OUTPUT
`@Search`	`nvarchar(64)`	input
`@LowerLimit`	`nvarchar(64)`	input
`@UpperLimit`	`nvarchar(64)`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

None extracted.

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @Search @LowerLimit @UpperLimit @erg @SearchWildCard @LowerLimitWildCard @UpperLimitWildCard @MinCmp @CmpSearch @CmpLowerLimit @CmpUpperLimit @LenSearch @LenUpperLimit @LenLowerLimit @search @lenUpperLimit @mincmp @lenSearch @Erg @cmpSearch

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

No reverse dependencies extracted.