>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,"(*)","")
>
>

replace horse_name with left(horse_name, at("(", horse_name)-1))