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