Nsryjdtyk

Let us consider below a table.

Input Table

Emp_ID     EmployeeName 

1           Mark hos

2           jhon carte

3           Mike hold   

4           Mark Danny

5           Stacy hodegf  

How to retrieve Output like below

Output Table

Mark

jhon

Mike

Mark

Stacy

You can use Left with CharIndex:

First, Create and populate sample table (Please save us this step in your future questions)

DECLARE @T AS TABLE

(

    Emp_ID int,

    EmployeeName varchar(20)

)



INSERT INTO @T (Emp_Id, EmployeeName ) VALUES

(1, 'Mark hos'),

(2, 'jhon carte'),

(3, 'Mike hold'),  

(4, 'Mark Danny'),

(5, 'Stacy hodegf'),

(6, 'NoSpaceHere')

The query:

SELECT Emp_Id, LEFT(EmployeeName, CHARINDEX(' ', EmployeeName +' ')) As FirstName

FROM @T

Results:

Emp_Id  FirstName

1       Mark 

2       jhon 

3       Mike 

4       Mark 

5       Stacy 

6       NoSpaceHere

Please note that I've added a trailing space to the EmployeeName in the charindex function to return the entire EmployeeName in case there is no space there.

you can try using substring() and charindex() function

select substring(EmployeeName,0,charindex(' ',EmployeeName))

from tablename

you can use SUBSTRING, CHARINDEX as the other answers suggest, or you can take a look at STRING_SPLIT which is probably a better solution:

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

CREATE TABLE #TempEmp

(

    Emp_ID          INT,

    EmployeeName    VARCHAR(100)

)



INSERT INTO #TempEmp

SELECT 1,'Mark hos' UNION

SELECT 2,'jhon carte' UNION

SELECT 3,'Mike hold' UNION  

SELECT 4,'Mark Danny' UNION

SELECT 5,'Stacy hodegf'



SELECT 

    SUBSTRING(EmployeeName, 1, CASE WHEN CHARINDEX(' ', EmployeeName)>0 THEN CHARINDEX(' ', EmployeeName) - 1 ELSE LEN(EmployeeName) END ) AS Firstname FROM #TempEmp