Barry,

<< Is this syntax "select ... from <select statement>" an SQL standard?
Because I haven't seen it before using EDB? >>

It's called a "derived table", and it's simply a way of using a view in a
temporary and query-specific way, as opposed to having to define the view in
the database itself.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Barry,

<< It's too bad Tim didn't allow for user defined function calls in a
computed column like you can in a generated column, but I suspect he did it
this way for speed, which I understand. >>

Computed columns can be re-computed on the client side of a CS connection,
so they can only refer to whatever is available in that context, that is,
current-row columns only and no UDFs or other objects that are in the
database catalog on the server side.  If you want that, then you have to go
with generated columns instead.

Tim Young
Elevate Software
www.elevatesoft.com