Birthdates List

Hi all,

I'm trying to create a list, in list manager, that will pull birthdates based on the month someone was born, and not the year or day.

I was wondering if there was a way to put a wildcard below on the year and day, so it just pulls everyone for instance born in November.

Any help will be greatly appreciated.

Many thanks

Lee

SELECT DISTINCT a.customer_no
FROM V_CUSTOMER_WITH_PRIMARY_GROUP AS a WITH (NOLOCK)
WHERE a.inactive = 1
AND EXISTS (SELECT *
FROM TX_CUST_KEYWORD WITH (NOLOCK)
WHERE TX_CUST_KEYWORD.customer_no IN (SELECT customer_no
FROM V_CUSTOMER_WITH_PRIMARY_GROUP
WHERE customer_no = a.customer_no)
AND CONVERT (DATETIME, TX_CUST_KEYWORD.key_value) = '2023/11/01'
AND TX_CUST_KEYWORD.keyword_no = 1)