SQL User Defined Function

[David Carwile]

I want to add a user defined function inside of an SQL string. I am
using the function to change a group of numbers in a string to a
specific format that can be sorted by Access(utilizin g 0s). Function
is called Zero pad and is from an old Access 97 magazine. My question
is how do I put the function with the SQL. I have written the string
correctly to include the function much like a Val() or CDate(). How
do I make the function known to the SQL engine(?) Thanks.

- Dave

[Gary Floam]

Re: SQL User Defined Function

David,

Just put the function call in the SQL string. For instance, where
DateString = MyFunction([DateValue])

The function must live on a module page.

Hope this helps,

Gary

"David Carwile" <carwile@avwtec h.com> wrote in message
news:8536f1ea.0 406250939.6e857 6ae@posting.goo gle.com...[color=blue]
> I want to add a user defined function inside of an SQL string. I am
> using the function to change a group of numbers in a string to a
> specific format that can be sorted by Access(utilizin g 0s). Function
> is called Zero pad and is from an old Access 97 magazine. My question
> is how do I put the function with the SQL. I have written the string
> correctly to include the function much like a Val() or CDate(). How
> do I make the function known to the SQL engine(?) Thanks.
>
> - Dave[/color]