Converting text to number producing error data

[alcifer_c]

I am using the funtion:

Clng([text field]) to convert a text field into a number so that I can link in a query. Because it is an informix database, I cannot change the underlying table format.

When I run the query, the data is showing "Error".

I tried changing the other table to text and linking but it doesn't seem to link properly because the query doesn't work.

Your advice appreciated.

 

[RuralGuy]

Have you looked at a sample of the data in this field to make sure it is "numeric" text?

 

[alcifer_c]

yes, it definitely is.

Within the informix database, these two fields are linked.

 

[alcifer_c]

Who would've thunk it...

I've got three different fields with similar names. Two are linked and one is not. You're reply got me to look and make sure. Turns out the one I wanted to change to numeric is indeed numeric but isn't the right field to link to.

Thanks!

 

[RuralGuy]

Sometimes all that is needed is the right question at the right time.

 

[alcifer_c]

Thanks!

You bet... if only I had all the right answers at the right time, I'd be all set!