turn string into numeric using query

  • Thread starter Thread starter Randal
  • Start date Start date
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.
 
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.
 
Back
Top