>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.