TO_NUMBER

Converts a value to a numerical format

Updated over a week ago

Description

The TO_NUMBER() function is used to convert a value, which may be in text or other formats, into a numerical format. This is particularly useful when you have non-numeric data that needs to be treated as numbers for mathematical operations or comparisons.

Syntax

TO_NUMBER(value)

Variables

  1. value: The value you want to convert into a numerical format. This can be a number in text form, a decimal number, or any other compatible data type that can be converted to a numeric value.

Example

TO_NUMBER(`Weight`)

Name

DOB

Weight

TO_NUMBER

Anne

2/06/2012

54

54

Giacomo

2/15/1983

61

61

Kameko

4/19/1969

92

92

Nasim

3/02/2007

97

97

Orlando

4/28/1988

92

92


โ€‹

Did this answer your question?