Is there anyway to replace spaces in a table field? I have a table where I need to replace all spaces in that field with a hyphen. I have tried :
replace substr(field,2,1) with '-';
for substr(field,2,1) = ' '

This gives me an unrecoginzed phrase error. Is there a better way to do this? Please help!!! Thanks.