cancel
Showing results for 
Search instead for 
Did you mean: 

Convert to Number in SQL Expression Data Base

ancook
Meteoroid

Convert to Number in SQL Expression Data Base

How would I convert this V_String to a number?Screenshot 2024-05-23 112649..png

3 REPLIES 3
ancook
Meteoroid

Convert to Number in SQL Expression Data Base

How would I convert this V_String to a number?Screenshot 2024-05-23 112649..png

terry10
Quasar

Re: Convert to Number in SQL Expression Data Base

Use the ToNumber function in a formula tool

Highlighted
Raj
Nebula

Re: Convert to Number in SQL Expression Data Base

@ancook 
tonumber([Review_Count])

hope this helps you

apathetichell
Arcturus

Re: Convert to Number in SQL Expression Data Base

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.