It's a common request to get a list of people whose birthday (or an anniversary date) falls in the specified date range w/o regard to the year.

T-SQL has CHARINDEX and PATINDEX functions that return the position of one character expression in another. The ufn_AT and ufn_RAT functions add the ability to search for specified occurrences and to search from right to left.

Source: How to identify your SQL Server version and edition