Convert Srting to Integer inside SQL

[Joan Josep]

Hi all,

I have a question, I have a string type fiel, (ex. "3") how can I get it in an SQL phrase and returned as an integer?

Can I do this??

SQLPhrase = "SELECT VAL(THE_FIELD) FROM MYTABLE WHERE ..."


...

Thanks in advance.