how to search First name from a column in sql ?

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

hi ....

i have a table in which i am entering employee full name in one column ... like this -

id Empname LoanSubscriptionDate IsActive

1 Rohit Kumar 30/12/2013 1

2 BabuLal Tiwari 4/08/2012 0

3 Ramcharan Kumar Garg 9/11/2013 1

And i want a list of name which only contain first name , i.e. (as given result set of above table ) ---

Emp

Rohit
BabuLal
Ramcharan

Pls give any idea ...

Posted 27-Jan-14 23:16pm

GDdixit

Add a Solution

2 solutions

Solution 1

T-SQL: Most Practical Split Function[^]

Posted 27-Jan-14 23:18pm

Kornfeld Eliyahu Peter

Comments

GDdixit 28-Jan-14 5:45am

there is nothing at the link....

Kornfeld Eliyahu Peter 28-Jan-14 5:48am

Funny it leads me to a good article about string splitting in SQL...

Add a Solution

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

Jorge J. Martins · Accepted Answer · 2014-01-27T23:43:00

Solution 2

Hi, assuming that after the first name you have a space you can try this:

SELECT LEFT(Empname, CHARINDEX(' ', Empname) - 1) AS FistName FROM YourTable

Posted 27-Jan-14 23:43pm

Jorge J. Martins

how to search First name from a column in sql ?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to search First name from a column in sql ?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us