pervasive - Concat two columns in Where Clause in PSQL v11 -

select concat(rtrim(xyz.firstname), rtrim(xyz.lastname)) person xyz person = ('johnsmith') 

the above works input parameter have space in example "john smith". tried adding

 person = ltrim('john smith') 

but did not work either.

the query:

select concat(rtrim(xyz.firstname), rtrim(xyz.lastname)) person xyz person = ('jon smith') 

won't return records because of space , rtriming fields.
use like:

select concat(rtrim(xyz.firstname), concat(' ', rtrim(xyz.lastname))) person xyz person = ('jon smith') 

notice concat , space (' ') in select portion.