question Select statement

G

Guest

Hi All,
when I use the following statement
Select col1,col5,0.0,col9,0.0

the datatable shows the zeros as int not currency, how can I ensure the zero is picked up as
a currency/decimal ?

MAny Thanks
 
G

Gary Walter

when I use the following statement
Select col1,col5,0.0,col9,0.0

the datatable shows the zeros as int not currency, how can I ensure the
zero is picked up as
a currency/decimal ?
Click to expand...
one way:

SELECT
col1,
col5,
CCur(0),
col9,
CCur(0)
......
 
Top