Hello
I have a field in my SQL Server database that is Json, how do I write a query to only get marketing consent as yes.
This is a Json example.
[Type]Contractual[Categories]EMAIL=Yes;Post=Yes;TEXT=Yes;Phone=Yes;[/Categories][/Type]<br/>[Type]Marketing[Categories]EMAIL=Yes;Post=Yes;TEXT=Yes;Phone=Yes;[/Categories][/Type]<br/>
Thank you for reading;
Regards
Graham