Fabrício Fadel Kammer wrote:

>Hi all,
>
>Can I create a stored procedure to format a number and return a string
>with a number formated??? Like 1.000,00 or 000100000...
>
>And can I create a procedure view in Firebird like I use in Oracle????
>
>Thanks again
>
>Fabricio F. Kammer
>Conchal/SP Brazil
>
>

Fabricio,

You could, but I suggest you to let formatting to be on the client side,
or if you really wish it on the server side use an UDF, search for rFunc
UDF library (I think it is on sourceforge).

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br