Home » RDBMS Server » Server Administration » Re: Query a column and remove everything after the space
Re: Query a column and remove everything after the space [message #373506] Thu, 19 April 2001 19:26
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
select substr('Dell Micro Computers Inc', 1, instr('Dell Micro Computers Inc', ' ')-1), length(substr('Dell Micro Computers Inc', 1, instr('Dell Micro Computers Inc', ' ')-1)) from dual;

Report message to a moderator

Previous Topic: Query a column and remove everything after the space
Next Topic: Problem with foreign key to a unique key
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:01:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.