Finding the month in a birthdate

Chris,

In list manager I used the following and received back just September birthdays.

Select Distinct a.customer_no

 From t_customer a (NOLOCK)

JOIN TX_CUST_KEYWORD e (NOLOCK) ON a.customer_no = e.customer_no

 Where  IsNull(a.inactive, 1) = 1

 AND e.key_value like '%09%'  AND e.keyword_no = 1

Thanks,

Bobby Moseley

Computer Services Manager

1921 W, Bell

Houston, TX 77019

(713) 535-3253

I'm trying to find all my March birthdates and Anniversaries, as entered in attributes in the format of mm/dd/yyyy.

How would I set up the search to find "03" in the two leftmost characters? 

I'd like to avoid getting anyone that was born/married on the 3rd day of the month.

It seems this is kind of like a reverse wild-card.  Rather than finding within a string of characters, I'm trying to limit it to only specific characters within the field.

Is this even possible?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Sheila,

Because the date is stored in the birth date as [1989-02-15] try adding a DASH on each side the month.

Select Distinct a.customer_no, e.*

 From t_customer a (NOLOCK)

JOIN TX_CUST_KEYWORD e (NOLOCK) ON a.customer_no = e.customer_no

 Where  IsNull(a.inactive, 1) = 1

 AND e.key_value like '%-01-%'  AND e.keyword_no = 1

Thanks,

Bobby Moseley

Computer Services Manager

1921 W, Bell

Houston, TX 77019

(713) 535-3253

I used this in the manual edit in list maker but unfortunately, with "01" as the parameter, it pulled birthdays in January AND birthdays on the 1st of any month.

Thoughts?