How to get only the first value before delimeter in SQL?

Question

I have value like

b10F|b3432R|b2134D

I need to get only the first value before the pipe:

b10F

How can I do that?

Have you reviewed the numerous string functions available in your specific RDBMS? — Stu, Apr 20 '22 at 08:41
You really need to reveal the exact SQL _database_ you are using (e.g. MySQL, SQL Server, Oracle, Postgres, etc.). Every database has its own peculiar string API. — Tim Biegeleisen, Apr 20 '22 at 08:41
Does this answer your question? [Split string on only first occurance of character/delimiter](https://stackoverflow.com/questions/13430905/split-string-on-only-first-occurance-of-character-delimiter) — ikweethetniet, Apr 20 '22 at 09:02
Even more duplicates can be found with a simple [search](https://www.google.com/search?q=Get+first+delimiter+VALUE+sql+server+site:stackoverflow.com). — Thom A, Apr 20 '22 at 09:07

score 0 · Answer 1 · answered Apr 20 '22 at 08:39

0

use mysql query with SUBSTRING_INDEX

SELECT SUBSTRING_INDEX("b10F|b3432R|b2134D", "|", 1)

answered Apr 20 '22 at 08:39

Bhargav Chudasama

2

Don't use double quotes for string literals. – Tim Biegeleisen Apr 20 '22 at 08:41
Getting this error : 'SUBSTRING_INDEX' is not a recognized built-in function name. – Saksham Srivastava Apr 20 '22 at 08:43
which SQL your are using? `e.g. MySQL, SQL Server, Oracle, Postgres, etc` – Bhargav Chudasama Apr 20 '22 at 08:43
using SQL Server – Saksham Srivastava Apr 20 '22 at 08:45

DhruvJoshi · Answer 2 · 2022-04-20T09:27:12.100

0

Maybe use this query which uses CHARINDEX function to find the location of first pipe character and then uses LEFT to get data till that position -1

 SELECT 
      LEFT(
             'b10F|b3432R|b2134D',
              CHARINDEX('|', 'b10F|b3432R|b2134D' ) -1 
          )AS Output;

edited Apr 20 '22 at 09:27

answered Apr 20 '22 at 08:55

DhruvJoshi

2 Answers2