As table
The position Contactsid
Administration/financial commissioner, 3, 4
Financial commissioner 3
Operators department manager 33

Want to according to three query administration/financial commissioner and financial commissioner, don't operators department manager of 33

CodePudding user response:

", "+ Contactsid +", "the Contains (", 3")

CodePudding user response:

 Contacts. Any (x=& gt; X.C ontactsid. Split (', '). The Where (id=& gt; Id=="3")) 

CodePudding user response:

Contactsid. Split (', '). The Contains (" 3 ")

CodePudding user response:

refer to the second floor stherix response:

 Contacts. Any (x=& gt; X.C ontactsid. Split (', '). The Where (id=& gt; Id=="3")) 

Write the wrong should be

 Contacts. The Where (x=& gt; X.C ontactsid. Split (', '). Any (id=& gt; Id=="3")) 

CodePudding user response:

! Contactsid. The Contains (" 3 ")

CodePudding user response:

! Contactsid. The Contains (" 33 ")

CodePudding user response:

To learn...