how to check a trailing space in a string,urgent!

[mkey]

Hi all,

string 1:'abc def'
string 2:'abcdef '

I know checking space between a string (string 1) is easy. But how do you check for a trailing space in the string 2?

Thanks!

 

[rcurva]

How about the INSTR function?

1 SELECT INSTR('abcdef ',' ')
2* FROM sys.dual
SQL->/

INSTR('ABCDEF','')
------------------
7

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[lewisp]

If you want a boolean return you could use

SELECT columns
FROM table
WHERE string2 != Rtrim(string2);