How would I convert this V_String to a number?
Use the ToNumber function in a formula tool
@ancook
tonumber([Review_Count])
hope this helps you
create a new field and use a
CAST("REVIEW_COUNT", AS int)
I'd recommend reviewing your db's documentation for any other specifics on numeric types - or error handling.
note 'review_count' in normal SQL is a value whereas "review_count" is a field.