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(utilizing 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]

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" <ca*****@avwtech.com> wrote in message
news:85**************************@posting.google.c om...

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(utilizing 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