Pervasive SQL equilivent for INSTR

Manah · #1 (**permalink**) 04-30-10, 00:42

Is there a function/procedure to replace full stops in a particular field with a blank.

Example: P.O.Box ABC with P O Box ABC

Thanks

mirtheil · #2 (**permalink**) 04-30-10, 07:23

What version of PSQL?
I did the following using the REPLACE function:

Code:

create table dbf (f1 char(10))#
insert into dbf (f1) values ('P.O. Box')#
select f1, replace(f1,'.',' ') from dbf#

Manah · #3 (**permalink**) 05-06-10, 21:11

I never thought of the 'replace' command, it works perfectly.

Thanks for your assistance with this.