My String is "SingNet-SOC_201503_0012 - Severity 4 - SingNet - NET206 CORP-NET - Access List Change - Juniper[Attachment Encrypted]"
DB Column Value is "Access List Change - Juniper[Attachment Encrypted]"
How to check the substring of a string with sql Database table column Values....
i wrote a query like this
select Subjects from SubjectsTable where CONTAINS(Subjects,' SingNet-SOC_201503_0012 - Severity 4 - SingNet - NET206 CORP-NET - Access List Change - Juniper[Attachment Encrypted]')
CONTAINS(Subjects,' SingNet-SOC_201503_0012 - Severity 4 - SingNet - NET206 CORP-NET - Access List Change - Juniper[Attachment Encrypted]')
Subjects------- from db...Suppose Subject is Access List Change - Juniper[Attachment Encrypted]
and the 2 part of contains method comes from db
SingNet-SOC_201503_0012 - Severity 4 - SingNet ...
Go to the complete details ...