Get every string before character in SQL Server

Question

I got two record in table which is as below -:

1.123-21
2.123-21-30

How to query for all string before certain place of character . Below shown expected output

1. 123-21 -> 123 
2. 123-21-30 ->123-21

How can I solve it?

What is the logic here exactly? You don't actually explain it. You say you want the string before a certain characters, but what is that character. If it's -, which are both rows not 123? — Thom A
– Thom A ♦, Commented Jan 26, 2023 at 9:02
Assuming something extremely simple: last 3 chars are always CharSpecialDigitDigit : — Bogdan Sahlean
– Bogdan Sahlean, Commented Jan 26, 2023 at 13:39

M.Ali · Accepted Answer · 2023-01-26 09:04:40Z

2

DECLARE @T TABLE (Vals VARCHAR(100))
INSERT INTO @T(Vals) VALUES ('123-21') , ('123-21-30')

SELECT LEFT(Vals, LEN(Vals) - CHARINDEX('-', REVERSE(Vals)) )
FROM @T

answered Jan 26, 2023 at 9:04

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Adam Fiqrie Putra Over a year ago

thanks....that's what im looking for

Charlieface Over a year ago

NULLIF(CHARINDEX('-', REVERSE(Vals)), 0) would be wise, in case it can't find it, otherwise you will get errors.

Collectives™ on Stack Overflow

Get every string before character in SQL Server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related