Re: Re: [firebird-support] Is Try_Cast in Firebird?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

 
 
W dniu 2016-10-17 10:17:33 użytkownik Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] <firebird-support@yahoogroups.com> napisał:
 
On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl
[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 Rotteveel
Hi Mark,
 
yes, PSQL function can be good but, you must specify type for input parameters
i have created feature request for it
http://tracker.firebirdsql.org/browse/CORE-5378 
 
regards,
Karol Bieniaszewski