if (@kind!='ARRAY') return cast('Using index in non array JSON' as int);

if (@kind!='ARRAY') return 'Using index in non array JSON';

Quote:

Msg 102, Level 15, State 1, Procedure json_Value, Line 31
Incorrect syntax near 'OFFSET'.
Msg 153, Level 15, State 2, Procedure json_Value, Line 31
Invalid usage of the option FIRST in the FETCH statement.

GO
/****** Object:  UserDefinedFunction [dbo].[json_Value]    Script Date: 6/16/2015 3:12:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** json_Value  ******/
CREATE FUNCTION [dbo].[json_Value](@json nvarchar(max),@path nvarchar(max))
RETURNS nvarchar(MAX) 
AS
BEGIN
    declare @data pJsonData
    declare @p1   TABLE(id int identity(1,1),name nvarchar(max))
    
    insert into @data       select id,parent,name,kind,value from dbo.json_Parse(@json)
    set @path=ltrim(rtrim(@path))
    if @path!='' insert into @p1(name)   select * from dbo.ufn_Split(@path,'.')
    
    declare @c0    int =0
    declare @cur    int =null
    declare @step   int =1
    declare @max    int =1
    declare @v      nvarchar(max)
    declare @v2      nvarchar(max)
    declare @kind   nvarchar(max)
    select  @max=max(id) from @p1
    select @c0=id,@cur=id, @kind=kind,@v=value from @data where parent=0           -- Current object is the one with parent =0
    if @cur is null return null                                             -- Should not happen
    while (@step<=@max and @c0 is not null) begin
        select @v=name from @p1 where id=@step
        set @c0 =null
        if (IsNumeric(@v)=1) begin
                if (@kind!='ARRAY') return cast('Using index in non array JSON' as int);
                set @v2=@v
                SELECT @c0=ID,@cur=ID,@kind=kind,@v=value FROM @data where parent=@cur 
                ORDER BY ID OFFSET convert(int,@v) ROWS FETCH FIRST 1 ROW ONLY
        end
        else begin
                if (@kind!='OBJECT') return cast('Using property name in a non-object JSON' as int);
                SELECT @c0=ID,@cur=ID,@kind=kind,@v=value FROM @data where parent=@cur and name=@v
        end
        set @step=@step+1
    end
    if @c0 is null return null
    if (@kind='OBJECT' or @kind='ARRAY') return dbo.json_toJson(@data,@cur)
    return @v
END

{"some":"value","aNullValue":null}

Unexpected token n

-- Handle NULL
if (upper(substring(@json,@start,4))='NULL') begin
        insert into @hierarchy(id,parent,name,kind,ppos,pend,value) values(@id,@parent,@name,'NULL',@start,@start+4,'')
        return
end

Quote:

Although SQL Server has announced native JSON support for SQL Server 2016, currently this support is not publicly available.