adding a dummy column 1

[flaviooooo]

Hey,

I'd like to add a 'dummy column' to my query. By this I mean I'd like a column that will always be empty, and has a name that doesn't exist in the table.

The meaning of all of this is that I export the query to excel, and send that excel file to a customer. The customer can then enter their data into that column. I wanna be stylish, and allready add a column name for them.

help (if you understand the problem)

Greetz

 

[dodge20]

sure

select mem_no, "" AS blank
from table

Here is what it returns.

mem_no blank

0000006
0000036
0000087
0000113
0000479
0000502
0000570
0000594
0000671
0000707
0000822
0000923
0000950
0001192

Dodge20

 

[flaviooooo]

Thanks mate,

Quite simple when you think about it

have a star on me