Hi Gurus,

I issue the following statement:

SQL>select wstext from table1;

The circuit breaker will be received and inspected for worn, damaged, and missing components.
Arc chutes will be removed and inspected for erosion
Contacts will be inspected for proper wipe and signs of deterioration.

Now I issue

SQL> select replace(WSTEXT,chr(10),chr(10)||'-')from table1;

The circuit breaker will be received and inspected
-Arc chutes will be removed and inspected for erosion
-Contacts will be inspected for proper wipe and signs of
-deterioration.

Why does the first line of output not have a '-'?

Any suggestions?

Thanks folks!