> -----Original Message-----
> From: Thater, William [mailto:[EMAIL PROTECTED]]
>
> try replace(lastname, ' '' ')
In the same way, if you want to create an object (e.g. table or username) with double quotes in the name, you have to use two double quotes.
SQL> create table "my ""favourite"" table" ("my ""favourite"" column" date) ;
Table créée.
SQL> select table_name, column_name from user_tab_columns ;
TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------
my "favourite" table my "favourite" column