[AccessD] Faking an SQL record

I vaguely remember someone supplying a syntax for "faking" a record in SQL
without having to actually supply a table name.
 
I want to return a single record from SQL that looks like:
 
HSomeCompanyName20061227
 
This is not data pulled out of any table, it is just "made up".
 
I can do this by aliasing the three fields and then telling SQL that it came
FROM SomeRealTable and then use a distinct clause etc.  But I seem to
remember some way of doing this without even supplying the name of a real
table.
 
Anyone have a clue what I am saying and how to do this?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com