SQL with access 97 mdb

Hi,
I use Delphi 5 with a Access 97 mdb and ADO.
In the delphi adoquery1 sql editor i want to do this :

SELECT agv(table1.pourcent)....
FROM ...

But table1.pourcent is a string.
How to convert to int ?

SELECT avg(cint(table1.pourcent)) dont work
also dont work : stringtostr, string_to_str...

Where i can find a document where all the function are detailled ?


Thanks.

lgc5800Asked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
what about

SELECT avg(pourcent)....  
FROM table1

??

pourcent is a textfield?
0
 
kretzschmarConnect With a Mentor Commented:
what is table1? a ttable instance?
0
 
lgc5800Author Commented:
table1 is a table in the access mdb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.