Hi,

Is there a way to use wildcards to update this recordset? I've got a column with 'madison county, cook county, dupage county' and i'd like to change it to
'madison, cook, dupage'

I can make each change individually, but is there a simpler way?

update physician
SET physician_practice_County1 = 'Madison'
where physician_practice_County1= 'Madison County'

I tried the following:

update physician
SET physician_practice_County1 = '%'
where physician_practice_County1= '% County'

all help appreciated.

why not just remove all occurrences of the word 'county' from the column, would that work?

Like this?

I tried this in a small test and it seems to work. Can you take a look and tell me if you see any errors? Thanks.

UPDATE physician
SET physician_practice_County1 =(REPLACE(physician_practice_County1 ,'County',''))

looks great

i would write it without the parentheses around the function

Pointing out the obvious: a WHERE clause would be a good idea here.