Use trim(both from firstname) || trim(both from lastname).
Boris Mogilevsky Programmer Analyst
Attachments
Library
Quick Reference
Archives
Sample Index
2005 Indexes