Home » RDBMS Server » Server Administration » Query a column and remove everything after the space
Query a column and remove everything after the space [message #373505] Thu, 19 April 2001 17:42 Go to next message
Ichiro
Messages: 2
Registered: April 2001
Junior Member
How do you query a column and remove everything after a space. Example:

Before: Dell Micro Computers Inc.
After: Dell

Report message to a moderator

Re: Query a column and remove everything after the space [message #373551 is a reply to message #373505] Mon, 23 April 2001 09:55 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

try this

select substr(column_name,1,instr(column_name,' ')) from table)name;

This will give only the character before the first space.

Report message to a moderator

Previous Topic: Translate
Next Topic: Urgent sql query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 00:43:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.