Answers for "T-SQL remove value after second ,"

sql server rtrim everything after character

SELECT   [FullName]
	    ,LEFT([FullName], CHARINDEX(',', [FullName]) - 1) AS [Surname]
	    ,REPLACE(SUBSTRING([FullName], CHARINDEX(',', [FullName]), LEN([FullName])), ',', '') AS [FirstName]
FROM    Employee

Posted by: Guest on August-04-2020

Code answers related to "T-SQL remove value after second ,"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "T-SQL remove value after second ,"

Code answers related to "T-SQL remove value after second ,"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "T-SQL remove value after second ,"

Code answers related to "T-SQL remove value after second ,"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us