I created a UDF to check to see if an alphanumeric phone number is toll-free. When I hardcode a parameter such as '800' it doesn't work (returns false, '0'). When I pass in a variable that contains '800', it does work (returns true, '1').
Here is my Function:
Create or Replace Function ccdlib/isTollFree ( ANI Char(20) )
external name 'CCDLIB/ANIPROCS($ISTOLLFREE)'
parameter style general
The service program procedure's prototype:
// Is the Number Toll-Free?
D $isTollFree PR n
D NPA 20a Const
Am I doing something wrong?
I tried changing the function parameter to VarChar, but that didn't resolve the issue.
CustomCall Data Systems