On Feb 16, 2008, at 7:50 PM, Christopher Green wrote:

> One of the things AS spoiled me with from early on is
> "whose clauses" (apparently also known as the by-test
> reference form). My question is, for those of you who
> reeeeally know other scripting/programming languages,
> what other languages have this funcionality as a basic
> feature??
>
> Anyone?

The "WHERE" clause in SQL is essentially the same thing.

SELECT lastname FROM users WHERE firstname LIKE 'Chris%'

This means roughly the same thing as...

get the lastname of every user whose firstname begins with 'Chris'

But the thing I love about SQL is that it omits articles and copulae.  
I call it a Tonto language, because most statements come out sounding  
like that character's speech in the Lone Ranger radio and TV series.  
Tarzan language would be equally applicable.

SQL also has a "HAVING" clause for restricting grouped data.

SELECT a, sum(b) FROM thistable GROUP BY a HAVING a < 100