Cognos audit package name conver to readable format :

Cognos audit package name conver to readable format :


SUBSTRING(
SUBSTRING([Audit].[Run Reports].[Package]
,CHARINDEX('=',[Audit].[Run Reports].[Package]
)+2,1000)
,1,
CHARINDEX(''']',SUBSTRING([Audit].[Run Reports].[Package]
,CHARINDEX('=',[Audit].[Run Reports].[Package]
)+2,1000)))