>Terry,
>
>>I figured that. I tried the manipulation in the function but it didn't work. What I settled on was 100 + caredays() - 100 AS CareDays. That gave me a 5 0.
>>Also, manipulation in the caredays function hides the purpose of the work. Putting the manipulation in the SQL code makes it easy to see and explain the whys to other programmers.
>
>You can also do just return a plain numeric from the function and do this in the SELECT:

SELECT whatever, 00+caredays()

That gives me 3-digit numeric with 1 or 2-digit return from function.

Hadn't thought of that. That fits my dataset better. I will use it.

Thanks

Terry