var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pervasive SQL equilivent for INSTR
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
What version of PSQL?
I did the following using the REPLACE function:
create table dbf (f1 char(10))#
insert into dbf (f1) values ('P.O. Box')#
select f1, replace(f1,'.',' ') from dbf#
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
I do not answer questions by email. Please post on the forum.
I never thought of the 'replace' command, it works perfectly.
Thanks for your assistance with this.