Hi,
I have this query SELECT CA.PartnerBankingAdditionalAttributes
FROM RltView.ActiveAndInactiveMembersPaymentDetails_V OV WITH (NOLOCK)
CROSS
APPLY (
SELECT FisrtName
,LastName
,IDNumber
,Address1
,Address2
,Address3
,FileType
FROM (VALUES(1))DT(x)
FOR JSON AUTO, WITHOUT_ARRAY_WRAPPER
) CA (PartnerBankingAdditionalAttributes)
WHERE OV.IsActive = 1
AND isPaid = 'Y'
I want to return data where LastName = 'John'
I tried this
AND JSON_VALUE(LastName, '$.LastName') = 'John'
but it's giving me errors