declare @ReferenceNo varchar(max) ='IB120219100105' set @ReferenceNo='{"Login_Id":"alex.maker","User_Name":"Samuel Jacob","Email_Id":"Samuel.Jacob@nestgroup.net","Mode":"M","Corporate_ID":"NeST","Establishment_ID":"12345678911830098344779998855552331","Reference_No":"IB120219100105"}' SELECT * FROM User_Sync_Log WHERE SyncLogRequest LIKE '%Reference_No": "%'+@ReferenceNo+'"%'
SyncLogRequest
'%Reference_No": "%{"Login_Id":"alex.maker","User_Name":"Samuel Jacob","Email_Id":"Samuel.Jacob@nestgroup.net","Mode":"M","Corporate_ID":"NeST","Establishment_ID":"12345678911830098344779998855552331","Reference_No":"IB120219100105"}"%
@ReferenceNo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)