|Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread|
|Messages 1 to 4 of 4 total|
|Get ASCII code of character|
|Thu, May 2 2019 9:49 AM||Permanent Link|
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?
|Mon, May 6 2019 11:27 AM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< 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.
|Fri, Sep 13 2019 8:36 AM||Permanent Link|
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?
|Sat, Sep 14 2019 3:26 AM||Permanent Link|
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)