-3

I have a query that in SQL Server that returns data like this:

1234-A
2345-BB
3456-C
5678-CC
4567-AA              
6789-B
01234-A
26857-ZZ

This is what I need it display:

A
B
C
C
A
B
A
Z

I need to get the first letter behind the '-'. How do I get this to display?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
N West
  • 1
  • 4

2 Answers2

1

Try this:

DECLARE @MyTable TABLE (MyCol VARCHAR(255));
INSERT @MyTable (MyCol)
VALUES ('1234-A'),('2345-BB'),('3456-C'),('5678-CC'),
       ('4567-AA'),('6789-B'),('01234-A'),('26857-ZZ');

SELECT SUBSTRING(MyCol, CHARINDEX('-', MyCol, 1) + 1, 1)
FROM @MyTable;

CHARINDEX finds where the '-' in the column value is.
SUBSTRING starts at that index + 1 and returns, in this case, 1 character.

squillman
  • 13,363
  • 3
  • 41
  • 60
  • 1
    @Scratte See my update. You can also look at the docs, this is pretty trivial t-sql. I made up my own schema since OP didn't include one. – squillman Oct 08 '21 at 22:59
-1

You can use substr In conjunction with instr to get the output

user17110175
  • 1