Subject | Re: Re: [firebird-support] Is Try_Cast in Firebird? |
---|---|
Author | liviuslivius |
Post date | 2016-10-17T10:10:27Z |
W dniu 2016-10-17 10:17:33 użytkownik Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> napisał:
On 17-10-2016 10:10, liviuslivius liviuslivius@...
[firebird-support] wrote:
> i know
> Cast('XXX' AS Integer)
> but is there
> try_Cast('XXX' AS Integer)
> like in MSSQL?
> you know if something can not by converted then return null.
No there isn't, although you could build something like that yourself in
Firebird 3 with PSQL functions.
Mark
--
Mark RotteveelHi Mark,yes, PSQL function can be good but, you must specify type for input parametersi have created feature request for itregards,Karol Bieniaszewski