>>2. Is there a slick way to get a textual representation of the month
>>and weekday (e.g. 'January' rather than 1)?
>>
>>
>
>Only with a UDF, e.g. DOW in FBUDF. FreeUDFLib also has some
>functions that return English strings from date types. Appendix 1 of
>the book is a summary of all the UDF syntaxes.
>
>

Hi actually you don't need a UDF !

This isn't what Id call slick but you can create a Stored procedure that
takes the number ant returns the text. I have done it and it works
fine. Perhaps I should be embarrassed about that :) In my defense we
have a policy of no Extra UDFs.



Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd




[Non-text portions of this message have been removed]