Hi All,

Is it possible to use wildcards with the strtran function.

I'd like to remove all the text between two parenthesis along with the parenthesis from a field in a table.

The horse_name field is populated with data like this:

Best Hanover (Best Hanover's Mommy)

I want to change the field to this:

Best Hanover

Here's a sample of what I've tried but doesn't work.

replace horse_name with strtran(horse_name,"(*)","")


Any help would be appreciated.

TIA

Jim Harvey