Re: LTRIM or TRIM Function

First of all, you should not use either. The trim functions are for removing whitespace. Use SUBSTR instead:

SUBSTR(first_name,1,1) || last_name

But have you thought of what you will do in case you for instance both have a Bob Smith and a Bill Smith?

-- 
Aleksander Dragnes