Include in SELECT a column that isn't actually in the database

Question

I'm trying to execute a SELECT statement that includes a column of a static string value. I've done this in Access, but never with raw SQL. Is this possible?

Example:

 Name  | Status  ------+--------  John  | Unpaid  Terry | Unpaid  Joe   | Unpaid 

In the above example, the "Status" column doesn't exist in the database.

Answer 1

You may want to use:

SELECT Name, 'Unpaid' AS Status FROM table; 

---

The SELECT clause syntax, as defined in MSDN: SELECT Clause (Transact-SQL), is as follows:

SELECT [ ALL | DISTINCT ] [ TOP ( expression ) [ PERCENT ] [ WITH TIES ] ]  <select_list>  

Where the expression can be a constant, function, any combination of column names, constants, and functions connected by an operator or operators, or a subquery.