dbo.QBM_FGIColumnFitsContentShort

1   create   function dbo.QBM_FGIColumnFitsContentShort(@TableName varchar(30) , @columnname varchar(30) ) returns bit as begin   declare @erg bit
2 = 0 declare @maxLen int declare @datatype nvarchar(64) if @TableName in (select TableName from QBM_VStartupTables) begin select top 1 @maxLen = CHARACTER_MAXIMUM_LENGTH
3 from INFORMATION_SCHEMA.COLUMNS cc where cc.COLUMN_NAME = @columnname and cc.TABLE_NAME = @TableName end else begin select top 1 @maxLen = cc.SchemaDataLen
4 from DialogColumn cc with (readpast) join DialogTable t with (readpast) on cc.UID_DialogTable = t.UID_DialogTable where cc.ColumnName = @columnname and
5 t.TableName = @TableName end  if @maxLen = -1 begin select @maxLen = 1000   return(@erg)  end if isnull(@maxLen, 0) = 0 or isnull(@maxLen, 0) > 198 begin
6 select @datatype = dbo.QBM_FGIColumnDataType(@TableName , @columnname) select @maxlen = case @datatype when 'int' then 4 when 'bigint' then 8 when 'bit'
7 then 1 when 'float' then 8 when 'bigint' then 8 when 'datetime' then 8 when 'varbinary' then (@maxLen * 2) + 2  else  @maxLen end end if @maxLen <= 400
8 begin select @erg = 1 end endLabel: return(@erg) end 
9