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;
Previous Topic: Query a column and remove everything after the space
Next Topic: Problem with foreign key to a unique key
Goto Forum:
  


Current Time: Mon Dec 23 10:14:50 CST 2024