Try
Select substring('Mahesh/pra' from 9 for 1)

Kind regards
Poul

Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] På vegne af Mahesh Pratihari
Sendt: 7. maj 2012 16:44
Til: firebird-support@yahoogroups.com
Emne: [firebird-support] substring



Hi ,

Could you please help me how to get the reverse substring in Firebird
like in SQL

SELECT SUBSTRING('Mahesh/pra',9,1)

Which will returns 'r' in SQL , but in firebird in is returning null
values, Please help me

Thanks,

Mahesh Pratihari

Sonata Software Limited

Phone : +91 80 3097 1527

Mobile : +91 99808 37446

www.sonata-software.com<http://www.sonata-software.com> <http://www.sonata-software.com>

Please don't print this email unless you really need to. This will
preserve trees on our planet.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]