thanks for the quick answers!
I am a bit puzzled: I think what I have done is correct, but it does not return anything:
- I have concatenated first_name and last name like this:
TRIM(vname) & TRIM(nname) as name
- Then I have done a RESIDENT LOAD with a WHERE clause using the PEEK function:
WHERE Peek(Name, -1) = Name
That, however, returned 0 records. I guess then I'll have to get back to HR about that.