One question: what is better for such things ----- write UDFs or try to write a good STORED PROCEDURE?


-----Ursprüngliche Nachricht-----
Von: Alan McDonald [mailto:alan@...]
Gesendet: Donnerstag, 12. Februar 2004 11:50
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] formatting numbers

> Hi all,
>
> I want to process strings stored procedure.
>
> Examples:
> '1' -> '0001'
> '12345' -> '54321'
>
> How can I do this?
>
> Regards
>
> Jürgen

You could write a UDF to do this - but that might be some work. Otherwise
you can do it in an SP by CAST ing your integers and playing around with the
substring or F_MID functions available in the UDF library
Alan




Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cr4tkhg/M=267637.4521717.5694185.1261774/D=egroupweb/S=1705115386:HM/EXP=1076669454/A=1945638/R=0/*http://www.netflix.com/Default?mqso=60178383&partid=4521717> click here
<http://us.adserver.yahoo.com/l?M=267637.4521717.5694185.1261774/D=egroupweb/S=:HM/A=1945638/rand=765947793>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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