i.e.

SELECT ASCII( SUBSTRING(MYFIELD,1,1) ) FROM MYTABLE

should result in 65 if myfield starts with 'A'

We need such a functionality in scripts to create calculations and checks for IBAN and SWIFT-Codes within SQL.
Any possibility to get this as internal edb function?
Yusuf Zorlu
MicrotronX

Yusuf,

<< SELECT ASCII( SUBSTRING(MYFIELD,1,1) ) FROM MYTABLE

should result in 65 if myfield starts with 'A' >>

I'll see what I can do.  In the meantime, you should consider implementing any custom functions that you need as an external module in Delphi.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<  I'll see what I can do.  In the meantime, you should consider implementing any custom functions that you need as an external module in Delphi.

Any news here?
--
Yusuf Zorlu
MicrotronX

Yusuf


I think what Tim was suggesting was that its not high on his list, it might appear in the next build but he won't be doing a custom build to provide it.

Why not implement your own function. Its simple enough

CREATE FUNCTION "ASCII" (IN "InStr" VARCHAR COLLATE AFK_CI)
RETURNS INTEGER
BEGIN

RETURN  64+POS(UPPER(SUBSTR(InStr,1,1)),'ABCDEFGHIJKLMNOPQRSTUVWXYZ');

END
VERSION 1.00

Roy Lambert