Script or Calculation

[Heathbo]

I am importing data into a new database from an old database. The text in some of the fields doesn't match the new database. I know I can do a Case script, and that works to a point. The problem I'm running into is sometimes the data in the specific field is not wrong, but the case script still changes it. Am I missing something. Here is what I have

Case ( Data Files::Mov3 = "Old" ; "

[rogermax]

I think you will need to include (something along the lines of)

PatternCount(Data Files::Mov3,"Old") in the Case statement to check for the string "Old" in the field. Otherwise unless the field contained ONLY "Old" it would fail. I think.

[Heathbo]

Thank you, I have it working.