Home Forums Article Discussions Article Discussions by Author Discuss content posted by Raghavan CV T-SQL Query RE: T-SQL Query
chandrasekhar.ms
SSC-Addicted
Points: 412
More actions
April 15, 2008 at 3:35 am
#802418
You should not use or as per the question but you can use 'and'. So we can build a negative logic like this:
select * from std_tab
where datename(m, dob) <> 1 and datename(m, dob) <> 3 and so on...
Regards,
-Aazad.