>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.

replace myfield with chrtran(trim(myfield), [ ], [-])