Progress
SQL-92
Guide and Reference


TO_NUMBER Function

Converts the given character expression to a number value.

SYNTAX

TO_NUMBER ( char_expression ) 

EXAMPLE

This example illustrates the TO_NUMBER function and the SUBSTR function:

SELECT *
    FROM customer
    WHERE TO_NUMBER (SUBSTR (phone, 1, 3)) = 603 ; 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095