pervasive sql code

#1

how can the sql language be used to remove double quote characters from data
in a column in a pervasive table?

select replace(column, '*','in') from table, doesn't seem to work.

#2

With Pervasive.SQL V8,this worked:

SELECT replace(First_Name,'"',' ') FROM "Person"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

pervasive sql code

comp.databases.btrieve comp.databases.btrieve

pervasive sql code - 05-30-2006 , 01:38 PM

Re: pervasive sql code - 05-30-2006 , 05:49 PM