sql server question in strings

Question

1.00/5 (2 votes)

See more:

Hi all,
i have the data like this

name
south America
north America
East America
west America

required output is

name
south
north
East
west

Thanks & Regards,
prakash.ch

Posted 16-Sep-13 4:23am

prakash.chakrala

Updated 16-Sep-13 7:00am

Maciej Los

v2

Add a Solution

Comments

[no name] 16-Sep-13 10:25am

And? Did you maybe forget a question? Or maybe you had some sort of a problem with the code that you have written?

prakash.chakrala 16-Sep-13 10:28am

In name column i have the data like south america(and mentioned above) so my requirement is to
get output as south(and mentioned above)

[no name] 16-Sep-13 10:49am

Okay and so? What is your question or what is the problem? Did you actually try anything or do you expect us to do all of your work for you?

phil.o 16-Sep-13 10:30am

Nice requirement! Good luck!

Thanks7872 16-Sep-13 12:32pm

And so many members here on CP feels this as question... :-)

phil.o 16-Sep-13 13:11pm

If only I could do the same:

My actual wallet is -52.25 €
My requirement is my wallet has 1,000,000.00 €
Thank you.
Didn't try that with my account manager, but I'm pretty sure it wouldn't fit :)

RedDk 16-Sep-13 14:18pm

You should post this wish over in Hardware & Systems ;P

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

hypermellow · Answer 1 · 2013-09-16T04:38:00

Solution 1

Have a look at the REPLACE function
* Clicky *

SQL

SELECT REPLACE(NAME, ' America', '') AS [NAME] FROM tblAmericas;

Posted 16-Sep-13 4:38am

hypermellow

v2

Comments

Maciej Los 16-Sep-13 13:01pm

Well done!
+5!

gvprabu · Answer 2 · 2013-09-16T05:47:00

Solution 2

Hi,

Check the below code...

SQL

CREATE TABLE #Test (Name VARCHAR(100))

INSERT INTO #Test (Name)
SELECT 'south America'
UNION ALL SELECT 'north America'
UNION ALL SELECT 'East America'
UNION ALL SELECT 'west America'

SELECT Name , SUBSTRING(Name, 1, CHARINDEX(' ', Name,1))
FROM #Test

DROP TABLE #Test

Regards,
GVPrabu

Posted 16-Sep-13 5:47am

gvprabu

Comments

Maciej Los 16-Sep-13 13:00pm

Good work!
+5!