Calling external functions from SQL SELECT

Does anyone know whether (and if so how :) it is possible to call external
functions from SQL's SELECT statement in a similar way that MS Access allows
you call code in its VBA modules?
For example, I'd like to be able to do this:
SELECT Name, DOB, VeryComplexFunction([Table.Numeric]) AS NumericResult
FROM Table
where,
VeryComplexFunction is a function that I (or some other 3rd party)
provide, perhaps in a DLL, but which cannot be implemented in a UDF
Now, I currently do that in Access, but now need to migrate to SQL.
I be very grateful for for any help or pointers that anyone can offer.
Thanks in adavnce.A Shasore,
Take a look at sp_OA... stored procedures in BOL.
Ilya
"A Shasore" <AShasore@.discussions.microsoft.com> wrote in message
news:FF3F6C55-AB9A-4228-95C6-B0E564031EE9@.microsoft.com...
> Does anyone know whether (and if so how :) it is possible to call external
> functions from SQL's SELECT statement in a similar way that MS Access
allows
> you call code in its VBA modules?
> For example, I'd like to be able to do this:
> SELECT Name, DOB, VeryComplexFunction([Table.Numeric]) AS NumericResult
> FROM Table
> where,
> VeryComplexFunction is a function that I (or some other 3rd
party)
> provide, perhaps in a DLL, but which cannot be implemented in a UDF
> Now, I currently do that in Access, but now need to migrate to SQL.
> I be very grateful for for any help or pointers that anyone can offer.
> Thanks in adavnce.
>|||Hello Ilya,
Thanks for that, I'll take another look. Although from what (little) I know
of OLE Object support, I don't it can achieve the same thing.
In the meantime, thanks for your reply...
A.
"Ilya Margolin" wrote:

> A Shasore,
> Take a look at sp_OA... stored procedures in BOL.
> Ilya
> "A Shasore" <AShasore@.discussions.microsoft.com> wrote in message
> news:FF3F6C55-AB9A-4228-95C6-B0E564031EE9@.microsoft.com...
> allows
> party)
>
>