to make datatype as decimal or double for temprary column

[pol]

Hi all,
In the following sql example , how I can force the datatype as decimal or
as double. the column 'year_overhead' is not a table column. It is temprary
column created by sql. So please let me know how to make the datatype as
decimal or double.

SELECT
roq_salary.empname,
0.00 as year_overhead
FROM roq_salary ;

Something like that
select salaryamt, cast(0 as decimal(8,2)) as overhead from salary

With Regards
Pol

 

[Allen Browne]

If you execute the query under ADO (not merely in the Access interface), you
can create a table with a column of type:
DECIMAL (precision, scale)

CREATE TABLE Table1
SomeField DECIMAL (8,2);

 

[pol]

Thanks for the reply.

Is it possible to create a dummy column (decimal datatype)
with the sql itself.

I can give as follows in Access

Select
contact.name,
contact.addr1
' ' as remark
from contact

In the above example remark is dummy column . But is it possible to create
decimal column

With thanks
Pol

 

[Stefan Hoffmann]

hi,

In the following sql example , how I can force the datatype as decimal or
as double. the column 'year_overhead' is not a table column. It is temprary
column created by sql.

Use CDbl(0) As year_overhead.


mfG
--> stefan <--

 

[Allen Browne]

CDec() will create the right type, but you don't get so set the
scale/presision.