Split string function in SQL Server

Question

In SOL Server, I get the value for the parameter, @codeName, as "1023 - Hydrabad" from ASP.NET.

@codeName = "1023 - Hydrabad"

I want Hydrabad alone. How to split it?

4 upvotes for question and answer for a same user in less than 2 mins, it looks like false voting.... — Arulkumar, Jun 18 '19 at 07:42

Arulkumar · Answer 1 · 2019-06-18T08:02:22.617

1

Using RIGHT(), LEN() and CHARINDEX(), you can get the expected output:

SELECT TRIM(RIGHT(@codeName, LEN(@codeName) - CHARINDEX('-', @codeName)));

Sample execution:

DECLARE @codeName AS VARCHAR (100) = '1023 - Hydrabad';
SELECT TRIM(RIGHT(@codeName, LEN(@codeName) - CHARINDEX('-', @codeName)));

edited Jun 18 '19 at 08:02

answered Jun 18 '19 at 07:39

Arulkumar

score 0 · Answer 2 · answered Jun 18 '19 at 07:38

0

You can use SQL Server's SUBSTRING and CHARINDEX functions:

DECLARE @codeName VarChar(100)
SET @codeName = '1023 - Hydrabad'
SELECT SUBSTRING(@codeName, CHARINDEX('-', @codeName) + 2, 100)

or use appropriate similar .NET methods in your code behind.

answered Jun 18 '19 at 07:38

2 Answers2