Convert to Number in SQL Expression Data Base
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ancook
6 - Meteoroid
‎05-23-2024
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How would I convert this V_String to a number?
Labels:
- Labels:
- Common Use Cases
- Database Connection
3 REPLIES 3
terry10
12 - Quasar
‎05-23-2024
11:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use the ToNumber function in a formula tool
Raj
16 - Nebula
‎05-23-2024
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ancook
tonumber([Review_Count])
hope this helps you
apathetichell
19 - Altair
‎05-23-2024
12:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
