Parse the xml in SQL server without case sensitive

 Here I am explaining how to parse the xml in SQL server without case sensitive

declare @inXML xml='<Page><parent>AndroidDhina</parent></Page>'

declare @nodename varchar(100)='PARENT',@nodevalue varchar(100)

set @inXML=convert(xml, replace (convert(varchar(max),@inXML),@nodename,upper(@nodename)))

declare @sql nvarchar(4000),@params nvarchar(3000) = N'@nodevalueout varchar(1000) output,@xmlin xml'

set @sql = 'Select @nodevalueout = x.value(' + '''' + upper(@nodename) + '[1]' + '''' + ',' + '''' + 'varchar(1000)' +  '''' + ') from @xmlin.nodes(' + '''' + '/Page' + '''' + ') as prod(x)'

exec sp_executesql @sql,@params,@xmlin =@inxml,@nodevalueout =@nodevalue output

select @nodevalue