exclude fields in a query

[Goodwill]

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 ('cre%','ame%','de%')

Thanks

[TheServant]

I believe you need to separate the WHERE clauses for LIKE searches:

SELECT * FROM dbo.da_accounts WHERE totals_group NOT LIKE ('cre%') OR  totals_group NOT LIKE ('ame%') OR  totals_group NOT LIKE ('de%')

[amitpatel66]

Try this:

 
select * from dbo.da_accounts where totals_group not in ('cre','ame','de')