Ah... works in IE but not FF (that's pretty weak though..)

Where's the video? I press play, but get a message that it can't find it... 🙁

You've identified one (of the two) most common ways to calculate age. The other one being the "I'm one year older if my birthday is today or was earlier this...

This is the closest I can get. You can extend the list of IDs without corresponding countries.

(ps: indentation seems to be lost during posting *sigh*)

declare @country table (

id int,

country varchar(15)

)

insert...