Question:
Hi All,
I want to be able to find all the contacts by using a wildcard search on eamil addresses.
When I look at ADR6, the field SMTP_ADDR is 241 long but is case sensitive.
There is a second field called SMTP_SEARCH which is upper case but is only 20 long.
At the moment I can either search using the first option but, obviously, I have the matching case issue. Or I can search on the first 20 characters on the email address, which is a bit restictive.
For example. Andy.Nother@BigCompany.co.uk will have ANDY.NOTHER@BIGCOMPA in the search field. If I search for *bigcompany* this will not be found using either field because the case doesn't match and it the pattern doesn't exist in the search field.
Has anyone done this and found a way around it ???
Cherers
James
Answer:
What about translating the long email address to all upper case in a temp field and searching that way? (after setting your wildcard search value to upper case.
Answer:
Gareth, is that you ?