MI-L Updating a field

[Ronning, Christine]

Hi all,

I'm trying to update the mapping type field for one of my tables based
on the service type.

I have used the following:

Update Facilities_Test2 Set Mapping_Type = "A"

This works fine.  However the following does not:

Update Facilities_Test2 Set Mapping_Type = "A" Where Service_Type = "H"

Any ideas?  Thanks,

Christine