turn string into numeric using query

R

Randal

I have a number stored in a text field in a linked VFP table. Is there a
way to convert it to a numeric a field using a query? I need to add it to
another number for the query results.
 
J

John Vinson

I have a number stored in a text field in a linked VFP table. Is there a
way to convert it to a numeric a field using a query? I need to add it to
another number for the query results.
Click to expand...

Use the Val() function: it converts a string (or the initial numeric
substring of a string) into a number.
 
Top