Select field1, field2 + var1 2

[shangrilla]

Hi:

I need some help modifying the following select statement.

Select fl, f2, f3, f4, f5 from tab1 into table tmptable

Now in addition to the above fields I want to add a global variable to the select statement that'll have the same value for all the records.

How should I go about this?

 

[Mike Gagnon]

shangrilla

Select fl,f2,f3,f4,f5,space(2) as f6 from tab1 into table tmptable
update temptable set f6 = "33"

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first or check this link

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[DSummZZZ]

Or:

Select fl,f2,f3,f4,f5, '33' as f6 from tab1 into table tmptable
Dave S.

 

[shangrilla]

What if the field I am trying to add has a numeric datatype.

 

[RLG07734]

Select fl,f2,f3,f4,f5, int(val('33')) as f6 from tab1 into table tmptable

 

[DSummZZZ]

Or:
Select fl,f2,f3,f4,f5, 33 as f6 from tab1 into table tmptable
Dave S.

 

[shangrilla]

Thanks Guys. I appreciate all your help.