At 11:50 AM 15-11-02 +0530, you wrote:

> Thanks i got that DLL and placed the libarary in
> IB_INSTALL/UDF and restarted the server but the server gives an error
> fucntion unknown do i have to do something more for the server to know
> about that DLL.
>
>Ajay.

Sorry, Ajay, I should not answer support questions so late at night. :-(

Did you declare the function to the database?

> declare external function f_DayOfMonth
> date
> returns
> integer by value
> entry_point 'DayOfMonth' module_name 'FreeUDFLib;

commit;

Now, here is what you *actually* need to do what you asked:

Select Count(ID), f_DayOfMonth (Msg_Date)
From DR_Main
Group By f_DayOfMonth (Msg_Date)

heLen