Kind of stuck on this one, I need to trim the leading spaces from only PEO_FirstName and it does not appear to be working. What would be the correct syntax for this line?
Upper(LTrim(PEO_FirstName)) & ' ' & Upper(PEO_LastName) as KEY|CustomerName,
Upper(LTrim(PEO_FirstName & ' ' & PEO_LastName)) as KEY|CustomerName,
It should work this way, if shouldn't make sure trailing spaces are what expected.
can you provide a sample data?
Upper(Trim(PEO_FirstName)) & ' ' & Upper(PEO_LastName) as KEY|CustomerName,
Can you upload an example.
The expression looks ok to me.
I would use TRIM(UPPER(PEO_FirstName)) rather than UPPER(TRIM(PEO_FirstName))
but I dont think that matters anyway
That did it! Thanks so much!
Retrieving data ...