Firebird - Firebird Functions

SELECT
   LEFT('JOAO SILVA',5),
   RIGHT('JOAO SILVA',5),

   lpad('TESTE_DIR',14,'*'),
   rpad('TESTE_ESQ',14,'*'),

   CEIL(12.87),
   FLOOR(12.87),

   maxvalue(1 , 1.34 , 8.98 ),
   minvalue(1 , 1.34 , 8.98 ),

   overlay('JOAO SILVA SANTOS' placing ' TESTA ' FROM 5 FOR 1) ,

   REPLACE('JOAO SILVA SANTOS','SILVA','TESTA'),

   reverse('OLA MUNDO')


FROM RDB$DATABASE