Link Search Menu Expand Document

TO_LONG

Converts a string to a numeric LONG data type.

Syntax 

TO_LONG(<exp>)
Parameter Description
<expr> Any numeric data types or numeric characters that resolve to a VARCHAR, TEXT, or STRING data type.

Example 

SELECT
	TO_LONG('1234567890');

Returns: 1234567890