Substring in IIF

Stukmeister · Mar 17, 2005

I need to compare the first three characters of string1 to the first three
characters of string2. How can I do this?

fredg · Mar 17, 2005

I need to compare the first three characters of string1 to the first three
characters of string2. How can I do this?

=IIf(Left(String1,3) = Left(String2,3),"Equal","Not Equal")

Stukmeister · Mar 17, 2005

Thanks a bunch!

fredg said:
=IIf(Left(String1,3) = Left(String2,3),"Equal","Not Equal")