RE: whitespaces

2002-02-18 Thread Abul Fazal
can i run to to eliminate trailing whitespaces. e.g. i have 'abc ' and want to update the table so any such data is set without the whitespace, in this case 'abc' the fiels is varchar2 8.1.7. cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

whitespaces

2002-02-14 Thread iashraf
Hi, What query can i run to to eliminate trailing whitespaces. e.g. i have 'abc ' and want to update the table so any such data is set without the whitespace, in this case 'abc' the fiels is varchar2 8.1.7. cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: whitespaces

2002-02-14 Thread Jon Baker
Title: RE: whitespaces use the rtrim function. rtrim(char[,set]) - char, with final characters removed after the last character not in set. set defaults to ' '. i.e.: update table set field=rtrim(field); Jon Baker Database Architect [EMAIL PROTECTED] www.netsec.net

RE: whitespaces

2002-02-14 Thread Kevin Lange
whitespaces. e.g. i have 'abc ' and want to update the table so any such data is set without the whitespace, in this case 'abc' the fiels is varchar2 8.1.7. cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: whitespaces

2002-02-14 Thread Steven Monaghan
: Thursday, February 14, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Hi, What query can i run to to eliminate trailing whitespaces. e.g. i have 'abc ' and want to update the table so any such data is set without the whitespace, in this case 'abc' the fiels is varchar2 8.1.7. cheers