var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: UPDATE using wildcard
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?
SET physician_practice_County1 = 'Madison'
where physician_practice_County1= 'Madison County'
I tried the following:
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?
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.
SET physician_practice_County1 =(REPLACE(physician_practice_County1 ,'County',''))
i would write it without the parentheses around the function
Pointing out the obvious: a WHERE clause would be a good idea here.
Originally Posted by hconnor