>Just like David pointed out, the query being optimizable is not a high priority - simply because I don't have hundreds of thousands of people on the list.
>
>However, an index on right(dtos(dob), 4) would make my code above optimizable.
Yes, but you need two different cases (similar to my solution) for years span.
If it's not broken, fix it until it is.
My Blog