Sorry - It won't let me do this -

To create the table -

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[co_audit_trail2](

[user_name] [varchar](60) NULL,

[date_of_change] [datetime] NULL,

[time_of_change] [varchar](16) NULL,

[bi] [varchar](8000) NULL,

[ai] [varchar](8000) NULL,

[modified_table] [varchar](60) NULL,

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

However when I run the part to create the data -

SELECT 'SELECT '

+ QUOTENAME(user_name,'''')+'*'

+ QUOTENAME(date_of_change,'''')+'*'

+ QUOTENAME(time_of_change,'''')+'*'

+ QUOTENAME(bi,'''')+'*'

+ QUOTENAME(ai,'''')+'*'

+ QUOTENAME(modified_table,'''')

+ ' UNION ALL'

FROM [dbo].[co_audit_trail] au

where au.modified_table = 'ih_officer'

The 6 results I would expect just come back as below -

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

NULL

NULL

NULL

NULL

NULL

NULL

(6 row(s) affected)