CAST,CONVERT,CELING,FLOOR DOES NOT WORK

  • Thread starter Thread starter Shiplu
  • Start date Start date
S

Shiplu

Hello all,
select CAST(35.340 AS INT)
the above sql doesn't work in ADO.NET,
any idea ?
Other functions mentioned in the subject does not work also
I am handling a CSV file using ADO.NET and C#.
I have posted previously but no answer.
I need it.
PLEASE HELP !
 
Oledb supports CLng(...)

So:

Clng([field1]) as myfield1

should do fine.
To bad but there was an handy site on MS somewhere providing all the
functions for oledb.
Lost it..

There is also Fix() to truncate.
Clng() will do a round.
 
Edwin,
Thank you very much. my problem is solved. I used Fix() which compats
with my requirments.
I am just a newbie in ADO.NET and I don't have any reference for that.
That's why the question arises.

Thank you
 
Back
Top