TRIM trailing spaces of a field 1

[selavarti]

Hello,

I have to trim trailing spaces on a feild on both sides.

I did


select TRIM(eqvn_name) as eqvn_name from eqvn where eqvn_name like '% ';

I feel this is right. But after running TRIM function when I query to check if there are any with trailing spaces. It is returning same set of results. Am I doing something wrong?

Thank you

 

[DotNetGnat]

then they are not spaces...they might other characters like chr(10) or Chr(13)

do this to find out...

SELECT ASCII(yourfield) from yourtable...

then do a replace() function to remove them

-DNG

 

[vongrunt]

Lemme guess: column is of type char, not varchar?

And TRIM() is not SQL Server function. LTRIM() and RTRIM() together do the same thing though.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLDenis]

If these are varchar fields, is ansi_padding off?
Run dbcc useroptions and find out

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[selavarti]

I am using SQL Navigator, but the database is in Orcale

I am looking at the options you guys gave..thank you

 

[selavarti]

And yes that field is Varchar

 

[SQLDenis]

For Oracle 10 go here (

http://www.tek-tips.com/threadminder.cfm?pid=1177)

for Oracle 9 go here (

http://www.tek-tips.com/threadminder.cfm?pid=759)

You will get better help there


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jbenson001]

Better to check in the Oracle forum, this is for MS sql server.

 

[selavarti]

Thank you.