Hi,

Is there a way to exclude fields in a query . If there are 20 fields in a column and you want to see all but 4, and I try the below statement and for some reason I do not get the result I need
select * from dbo.da_accounts where totals_group not like ('cre%','ame%', 'de%')
select * from dbo.da_accounts where totals_group <> ('cre%','ame%', 'de%')
select * from dbo.da_accounts where totals_group not in...