I am writing sql statement and need to convert char field which contains numeric value into decimal. I tried to use both:
CAST(expression AS data_type)
and
CONVERT (data_type[(length)], expression [, style]).
but looks like progress does not support both of these functions. When I use one of these functions in my select sql statement it gives me invalid sql statement message. Please, suggest me, which function I should use to make it work. I am using progress v8.3D.
Thank you very much.
CAST(expression AS data_type)
and
CONVERT (data_type[(length)], expression [, style]).
but looks like progress does not support both of these functions. When I use one of these functions in my select sql statement it gives me invalid sql statement message. Please, suggest me, which function I should use to make it work. I am using progress v8.3D.
Thank you very much.
