Re: Can you use RTRIM in select clause

asupcsi_at_cyberramp.net schrieb:
> Is it possible to use rtrim in the select clause of an Oracle sql stmt? I

You can check if it works with

select '''' || x || '''' from tablename;

Here blanks at the end are clearly visible cause the result strings are enclosed in "'" characters.

Now try
select '''' || rtrim(x) || '''' from tablename;

Now the blanks at the end should have been disappeared

Hpe that helps
Kai Received on Wed Jan 27 1999 - 03:48:15 CST