Add a same number

[hboisteau]

Hi,
I try to add the same number on a query, I have many line and I want add the same number for all of lines at the last colone on my query.
Thanks in advance.
HB

 

[jdraw]

Suppose you want to add "999" as the last column in your query:

Select fld1, fld2,fl3  ,"999" as lastColumn from YourTablename
Where   your_current_where_goes_here

 

[boblarson]

Or if you work in the QBE grid,

MyNewNameHere:999

 

[hboisteau]

Thanks you very much,
HB