Hello! Hope everyone is well. I'm trying to figure out how to code the following:

I need to compare the 1st 5 characters in field1 to the 1st 5 characters in field2. If they are equal, then I need to insert the result in SecondaryName field ELSE put in Name1 field. However, the comparision has to be done in all caps. So essentially, the first 5 characters in field1 and field2 will be all caps. Any ideas or suggestions????

This is what I have so far, but can't figure out the all caps part:

if the first 5 characters in ALL CAPS in Fields("NAME1") == _
first 5 ALL CAPS characters in Fields("ACCOUNT_NAME") THEN
Targets(0).Records("Contact_1").Fields("Secondary_ Name__c") else
Targets(0).Records("Contact_1").Fields("LastName")

Thanks in advance!
Diggity

MODERATOR: move to misc. programming?

diggity_d: Is that VB code? ...(looks similar to me, at least)

Basically, the operation would involve taking the first 5 characters [function Left()] of each string, convert that portion to uppercase [function UCase()] (I assume that the strings are NOT already in this format?) -- similar to this:
Thinking ahead, how well will this work when there are short names, such as Dan, Dave, Jan, Mark, Paul, or Walt? It might be necessary to also check the string lengths [function Len()] some(how/where) in the routine.

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!