How can I create a blank hardcoded column in a sql query

Question

I want have a query with a column that is a hardcoded value not from a table  can this be done   I need it basically as a placeholder that I am going to come back to later and fill in   example   SELECT hat  shoe  boat  somevalue   0 as placeholder FROM objects   then I would loop through this query later and fill in the placeholder  in this example someValue is not a field in objects  I need to fake it   I am doing this in coldfusion and using two datasources to complete one query  I have tried the space   function but have been unable to get it to work   Thanks

User · Accepted Answer

SELECT     hat      shoe      boat      0 as placeholder FROM     objects   And    as placeholder for strings

User · Answer

For varchars  you may need to do something like this   select convert varchar 25   NULL  as abc column into xyz table   If you try   select    as abc column into xyz table   you may get errors related to truncation  or an issue with null values  once you populate

User · Answer

SELECT     hat      shoe      boat      0 as placeholder -- for column having 0 value     FROM     objects   --OR    as Placeholder -- for blank column     --OR NULL as Placeholder -- for column having null value

User · Answer

The answers above are correct  and what I d consider the  best  answers   But just to be as complete as possible  you can also do this directly in CF using queryAddColumn   See http   www cfquickdocs com cf9  queryaddcolumn  Again  it s more efficient to do it at the database level    but it s good to be aware of as many alternatives as possible  IMO  of course

User · Answer

This should work on most databases   You can also select a blank string as your extra column like so   Select   Hat  Show  Boat     as SomeValue From   Objects

User · Answer

Thank you  in PostgreSQL this works for boolean   SELECT hat  shoe  boat  false as placeholder FROM objects

[sql] How can I create a blank/hardcoded column in a sql query?

Examples related to sql

Examples related to coldfusion