How can I grab the character value of a string, given an index ... in some Sql code?

Question

Hi folks,

i've got some string in some sql. i need to find out what the character is, for that string, given a index.

eg.

DECLARE @someString NVARCHAR(MAX) = 'hi folks'
DECLARE @index INT = 4 -- assuming the first index is 1, not 0.

now .. how do i get the character at 4th index slot, which is an 'f', in that example above.

thanks :)

Answer 1

Use the SUBSTRING function.

SUBSTRING ( value_expression ,start_expression , length_expression )

SELECT SUBSTRING ( @someString, @index, 1);

Answer 2

You can try

DECLARE @someString NVARCHAR(MAX) = 'hi folks' 
DECLARE @index INT = 4 -- assuming the first index is 1, not 0.
SELECT SUBSTRING(@someString, @index, 1)

Answer 3

Use SUBSTRING:

SELECT SUBSTRING(@someString, @index, 1)