August 11, 2005

Trim a spaces only string in Oracle

Suppose we have a spaces only string ' ',

In MS SQL Server,
Trim(' ') =''
Length(Trim(' ')) =0

However, in Oracle,
Trim(' ') is null
Length(Trim(' ')) is null

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)