Home » SQL & PL/SQL » SQL & PL/SQL » is there any function to remove white space in between words
is there any function to remove white space in between words [message #234191] Mon, 30 April 2007 06:59 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
I Konw about ltrim/rtrim function ,but i wanted to remove white space in between given string.so that i can use it for string comparision
(i.e input string ---> is Mr . Bala murali Krishnan
out put should be Mr.BalamuraliKrishnan)

by
balamuralikrishnan.s
Re: is there any function to remove white space in between words [message #234193 is a reply to message #234191] Mon, 30 April 2007 07:02 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
replace(col,' ','')

Regards
Michel
Previous Topic: How To Set Thursday and Friday as Weekends in the database
Next Topic: UTL_FILE problem (merged)
Goto Forum:
  


Current Time: Mon Dec 05 12:48:23 CST 2016

Total time taken to generate the page: 0.05797 seconds