question Select statement

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
......
 
Back
Top