Home » RDBMS Server » Server Administration » How to take spaces out on string
How to take spaces out on string [message #372360] Mon, 05 February 2001 09:12 Go to next message
Karri Lahtela
Messages: 16
Registered: November 2000
Junior Member
HI

I have column DESCRIPTION on table. DEDCRIPTION is VARCHAR2(2000) type. I need to take first 200 character whithout spaces. So 'A B C D' should be 'ABCD'
How can I do it?

BR Karri
Re: How to take spaces out on string [message #372361 is a reply to message #372360] Mon, 05 February 2001 10:02 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select substr(replace(colname,' ',''),1,200) from table name;

first argument is single space..

Suresh
Previous Topic: cannot delete*from
Next Topic: modify composite keys
Goto Forum:
  


Current Time: Mon Dec 23 00:27:35 CST 2024