SQL to update a character within a field? 1

[jimoblak]

Suppose that I have 3 records that looks like this:

123-23
12-321
1-56

Is there a simple SQL statement that can convert the hyphen to a space, without damaging the rest of the string in the field?

- - picklefish - -

 

[swampBoogie]

update t
set c = replace(c,'-',' ')
where c like '%-%'