This is called Scalar Subquery functions and will be available in TD 13.0.
Attachments
Library
Quick Reference
Archives
Sample Index
2008 Indexes