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