Help creating a new field using existing fields

[#1]

I have two fields:  Product and Real Product

Product	Real Product	Match
AL-111	AL-111MO	Y
CA-172	CA-183LA	N
MA-912	MA-912MO	Y
MA-912	MA-819MO	N

I want a new field, 'Match' that uses these two fields. If they first 5 characters are identical, I want the 'Match' field to say 'Y'. If not, 'N'

[joshabbott · Accepted solution]

Try something like:

if(left([Read Product],5) = left(Project,5), 'Y','N')