How to get last char in row in sql server

Question

bit rusty on sql. In the select expression, if the "string" field ends with the letter A, B or F Print 0k else, type No

I know that I need to make some substring, but I can not understand.

thanks

Answer 1

Use RIGHT:

SELECT Result = CASE WHEN RIGHT(string, 1) IN ('A','B','F') 
                THEN 'Ok' ELSE 'No' END

Answer 2

It could be a trick

select right('abc', 1)

Answer 3

He can work

DECLARE @STR VARCHAR(50)
SET @STR='DFGDFGF'
SELECT CASE WHEN (SELECT RIGHT(@STR, 1)) = 'A' THEN 'OK'
WHEN (SELECT RIGHT(@STR, 1)) = 'B' THEN 'OK'
WHEN (SELECT RIGHT(@STR, 1)) = 'F' THEN 'OK'
ELSE 'NOT OK' END