I have an index expression that looks like this "LEAD + UPPER(ST_NAME)". This always worked fine. Both fields were CHARACTER. When I changed LEAD to varchar it stopped working. Changed LEAD back to CHARACTER and it works again. What's up? Is there a work around or should I just abandon varchar?
Thanks