Re: Issues while storing a long dash in oracle

But my problem is that even if that character is processed and stored correctly in the database it would still be stored as a 2 byte character. In that case how do I make the following command, which works on the basis of no. of bytes, work correctly:

nvl(rpad(UPPER(substr(nvl( substr(column1,1,instr(column1,'(')-1),column1),

1,24)),24),'                        ')