Matching Valuelistitems

[spacetime]

What is the best way to match the contents of a field (text) with all items in a value list so that it returns a "yes no" or" 0 1"? Example: "song title" field matching to "original song title" field to compare for spelling mismatch, and flagging this mismatch.

Thanks.

[Vaughan]

Look at the Exact(field1, field2) function. It's case sensitive. To effectively make it case insensitive use the Lower() function...

Exact( Lower(field1), Lower(field2))