Home Forums Article Discussions Article Discussions by Author Discuss content posted by Raghavan CV T-SQL query RE: T-SQL query

  • May 5, 2008 at 1:29 am

    #810542

    you can use char/patindex as IN operator:

    where birthday is not NULL and charindex(cast(datepart(month, birthday) as varchar(8)) + ',', '1,3,4,5,7,8,') > 0