We are writing new interfaces for an SQL application and will have a lot of
uses for either DTS Active-x scripts or SQL Functions.

I know DTS Active-x conversions can be time consuming when processing a
large amount of records. Has anyone compared using an SQL user defined
function embedded in a query for charactor and number formatting compared to
DTS Active-x scripts?

Thanks

Stan

SQL is always faster than active-X for data manipulation or conversion.
To test this you could make two connections and time the amount of time
each takes to process.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!