As a further follow-up and question:

When using the QUOTENAME script to pull/extract data from table (example script below) I had the following issues:

5 fields that had Null values for all records (OpportunityID,TaskID, CaseID, CampaignID, ProjectID)

3 fields with '0' as value for all records (ContactMade, BPartnerAvailable, CustomerAvailable)

2 fields as ntext datatype (NoteTextRTF, NoteTextTrunc)

When running the QUOTENAME script below, if it hit one of these fields then the result was one column of 'NULL'. When I commented out these fields from the script, then was able to get the correct results.

QUESTION: How to code or fix the script to allow extraction of the above fields (Null, 0, ntext values) so that the QUOTENAME script will extract all of the data correctly?

Thanks.

QUOTENAME SCRIPT:

select 'Select '

+ QUOTENAME(NoteID,'''') + ','

+ QUOTENAME(CompanyID, '''') + ','

+ QUOTENAME(EmployeeID, '''') + ','

+ QUOTENAME(ContactID, '''') + ','

+ QUOTENAME(OpportunityID,'''') + ','

+ QUOTENAME(TaskID, '''') + ','

+ QUOTENAME(CaseID, '''') + ','

+ QUOTENAME(CampaignID, '''') + ','

QUOTENAME(ProjectID, '''') + ','

+ QUOTENAME(EntryDate, '''') + ','

+ QUOTENAME(NoteType, '''') + ','

+ QUOTENAME(NoteText, '''') + ','

+ QUOTENAME(NoteTextRTF, '''') + ','

+ QUOTENAME(NoteTextTrunc, '''') + ','

+ QUOTENAME(ContactMade, '''') + ','

+ QUOTENAME(BPartnerAvailable, '''') + ','

+ QUOTENAME(CustomerAvailable, '''') + ','

+ QUOTENAME(CreationDate, '''') + ','

+ QUOTENAME(ChangeDate, '''') + ','

+ QUOTENAME(ChangeDateOffline, '''') + ','

+ QUOTENAME(ChangedByID, '''') + ','

+ QUOTENAME(ChangedByIDOffline, '''') + ','

+ ' UNION ALL'

from dbo.NOTE_tblNote