Declare this UDF in yours Firebird, then use like Oracle.

DECLARE EXTERNAL FUNCTION SUBSTR
CSTRING (255),
INTEGER,
INTEGER
RETURNS CSTRING (255)
ENTRY_POINT 'SubStr' MODULE_NAME 'xlibudf';

... so search in google the udf: xlibudf (is one file w/extention .dll)
and then copy this to directory UDF where your FireBird was instaled.

Regards

Gerson



-----Mensagem original-----
De: monaasn [mailto:monalisa@...]
Enviada em: sexta-feira, 19 de novembro de 2004 08:48
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] substring



Dear All,

I have simple question need helped :

I have a table with data :

AA00,BB01,CC00,DD02

I want the data sort by substring from the third char, so the data
will appear : 00,00,01,02.

If I use SQL on oracle, I can use the syntax :

SELECT SUBSTR(column,2,2) FROM TABLE1

How the syntax can I use with firebird ?

Thanx,
MONALISA.





Yahoo! Groups Sponsor

ADVERTISEMENT
HYPERLINK
"http://us.ard.yahoo.com/SIG=1296137d6/M=298184.5584357.6650215.3001176/
D=groups/S=1705115386:HM/EXP=1100947741/A=2434970/R=0/SIG=11edksnhv/*htt
p://www.netflix.com/Default?mqso=60185402"click here
HYPERLINK
"http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=group
s/S=:HM/A=2434970/rand=706205739"


_____

Yahoo! Groups Links


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


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


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



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.797 / Virus Database: 541 - Release Date: 15/11/2004



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.797 / Virus Database: 541 - Release Date: 15/11/2004



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