NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > Search > Search any character field

Template Script: Search\Search any character field.sql

SELECT  'SELECT ''' + FQN + ''' as ObjectName, d.ColumnName, d.Value COLLATE SQL_Latin1_General_CP1_CI_AS  as Value
FROM ' + FQN + '
CROSS APPLY(SELECT ColumnName, Value FROM (VALUES' + Util.dbo.StringConcat('(''' + ColumnName + ''', ' + ColumnName + ')', ',
') + ') d(ColumnName, Value))d
WHERE d.VALUE COLLATE SQL_Latin1_General_CP1_CI_AS like ''%NEW-PAGE%''
UNION ALL'
FROM    Metadata.Columns
WHERE   COLUMNDEF LIKE '%CHAR%'
        AND type IN ('u')
GROUP BY FQN

Description for Template Script: Search\Search any character field.sql

Todo