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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 29 06:28:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.