add a temporary column with a value

select field1, field2, 'example' as TempField
from table1

This should work across different SQL implementations.