SQL Functions

In this case the functions are very simple. Each of the functions
described would get a different field out of the same file.   I'm just
wondering if this is an I/O nightmare in the making.  

Dave

>>It depends on how complex your functions are.
>>Rule of thumb I use with my UDFs is to make them as simple as possible
>>(single purpose functions).
>>If your UDFs are rather simple (i.e. add these two numbers and return
the
>>sum, convert decimal to date), there shouldn't be much overhead.
>>If each function runs another SQL statement in turn and the FROM file
has
>>lots of records, I can see lots of 'slamming' going on.
>>
>>Test in on a large file.
>>
>>Elvis
>>