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

2016-10-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 17-10-2016 12:10, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > 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 g

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

2016-10-17 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    W dniu 2016-10-17 10:17:33 użytkownik Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 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

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

2016-10-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

[firebird-support] Is Try_Cast in Firebird?

2016-10-17 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   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.   regards, Karol Bieniaszewski