trim the training spaces

[Z3]

I have a tool trying to pull all the column name. But one of the VIEWs have a column name that has a space at the end. I am trying to get rid of it using the following:

SELECT trim(ColumnName) COL_NAME
FROM DBC.COLUMNS
WHERE TableName = #Tablename#
AND DatabaseName = #database name#

But it still leave one space at the end. Is there way to get no trailing space at the end at all? I don't have a manual to help me.

 

[onpnt]

try useing the BOTH keyword


___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page[/sub]

 

[onpnt]

also take a look at dnoeth 's examples in thread328-522035

___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page[/sub]