General information
Category:
Coding, syntax & commands
Title:
Replacing spaces in a 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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only