One way to go around this problem is to get the number directly from Progress as opposed to you converting it. You can use To_NUMBER Progress function. The function will convert the Char_expression to a number. for example: you can have the following:

SELECT *

    FROM customer

    WHERE TO_NUMBER (SUBSTR (phone, 1, 3)) = 603 ;

I hope this helps.

Ahmad Khashan