How to extract String from a value of column in SQL Server

Question

There is a column that has value XYZ|YYYY-MM-DD and I have to extract this XYZ from that column.

XYZ has a different value for each row.

Please, show your current code and describe, what is the issue with it. If you have any errors, post them as plain text. — astentx
– astentx, Commented Jun 24, 2021 at 17:08
Sql Server 2008 has been end of life for a couple years now. That means no more patches... not even critical security updates. It's dangerous and irresponsible to still be using it. — Joel Coehoorn
– Joel Coehoorn, Commented Jun 24, 2021 at 17:08
Is XYZ a placeholder for n characters or is it always 3 characters? — Stu
– Stu, Commented Jun 24, 2021 at 17:09

Tim Biegeleisen · Accepted Answer · 2021-06-24 17:10:12Z

2

It looks like you just want the first substring before the pipe character. If so, then just use a basic substring operation:

SELECT SUBSTRING(col, 1, CHARINDEX('|', col) - 1)
FROM yourTable;

answered Jun 24, 2021 at 17:10

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

1 Answer 1