Try STRTRAN(field," ","-")
>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.
- Jayesh