Home » SQL & PL/SQL » SQL & PL/SQL » How to check space at varchar2 column (oracle)
How to check space at varchar2 column [message #340212] Tue, 12 August 2008 00:13 Go to next message
bsathishmca
Messages: 9
Registered: April 2006
Location: covai
Junior Member
Can any one suggest me that how to check whether a varchar2 column have space(both sides) in that?


Thanks in advance

Sathish
Re: How to check space at varchar2 column [message #340213 is a reply to message #340212] Tue, 12 August 2008 00:15 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Check Length After doing TRIM.(Left,Right Or Both)

Regards,
Rajat

Re: How to check space at varchar2 column [message #340266 is a reply to message #340213] Tue, 12 August 2008 02:34 Go to previous message
bsathishmca
Messages: 9
Registered: April 2006
Location: covai
Junior Member
Thank you very much..
Previous Topic: Tree structure query
Next Topic: Check for empty and null
Goto Forum:
  


Current Time: Sat Dec 03 05:52:46 CST 2016

Total time taken to generate the page: 0.10357 seconds