“split string and get first and last element in sql server” Code Answer’s

split first name and last name in sql

sql by Kwams         on Aug 02 2021 Donate Comment

0

1

# Name of table = names_table

2

# Name of column containing names = full_name

3

# Simply change the table and column name to what corresponds with your dataset

4

​

5

SELECT LEFT(full_name, STRPOS(primary_poc, ' ') -1 ) AS first_name,  

6

        RIGHT(full_name, LENGTH(primary_poc) - STRPOS(primary_poc, ' ')) AS last_name, name

7

FROM names_table;

8

​

9

# NB: This does not capture middle names

sql server split string last

sql by Bad Beaver on Oct 14 2021 Comment

0

1

SELECT SUBSTRING( string , LEN(string) -  CHARINDEX('/',REVERSE(string)) + 2  , LEN(string)  ) FROM SAMPLE;

Source: stackoverflow.com

Split string and get first and last element in sql server

sql by Cool Dev         on Jun 14 2022 Comment

0

1

DECLARE @String nvarchar(200) = 'I_love_my_country'

2

​

3

SELECT left(@String, charindex('_', @String) - 1) AS first_element 

4

SELECT reverse(left(reverse(@String), charindex('_', (reverse(@String))+'_' ) -1)) AS last_element 

Nguồn: https://www.codegrepper.com/code-examples/sql/split+string+and+get+first+and+last+element+in+sql+server