Subject Re: Re: [firebird-support] Is Try_Cast in Firebird?
Author liviuslivius
 
 
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 Rotteveel

Hi Mark,
 
yes, PSQL function can be good but, you must specify type for input parameters
i have created feature request for it
 
regards,
Karol Bieniaszewski