When a reference record is not found during the lookup for a VarChar record it returns ''. It there a way to change the '' to ~. I am using the INDEX function. INDEX('ALPS', expression, 1). the problem is '' returns 1 from the INDEX call. Not sure why but in order for my INDEX to work, I need to convert the ''.
Thanks in advance
Lookup Results
Moderators: chulett, rschirm, roy
Lookup Results
Jim Stewart