select statemennt 1

[plork123]

hi all

can someone tell me how ido this

i have select statemnet

select fielda, fieldb, fieldc from table but i want to do this


select fielda, fieldb, fieldc, selected='true' from table

how do i do the setting a value to a col. that doens't exist in a table

many thanks

 

[ceco]

SELECT fieldsa, fieldb, fieldc, 't' AS selected FROM table

 

[plork123]

thanks - so easy, oh well