Can anyone assist in the correct syntax to extract specific words from a string.

Field is "COMPANY"  I need to create groups that contain similar company types.

Group CITY OF (name of city)

Group TOWN OF (name of town)

Group STATE of (name of state)

Group VILLAGE of (name of village) or Village of X

The data within the field is not consistent in format.  Somewhere in the string there will be the city, or state or etc.

I am used to being able to extract "CONTAINS" and I can pull that information.

Thank you 


Edited by Woodworker - 26 Aug 2010 at 9:11am

Outstanding.  I don't know why that was so difficult for me.  Perfection.

Thank you...