1. Forums
  2. Programming
  3. Visual Basic .NET
  4. Help: MR ADMIN in syntax of NOT LIKE operator in VB.Net

Help: MR ADMIN in syntax of NOT LIKE operator in VB.Net

Submitted by michelle_paradero on
Please anyone i need help regarding the syntax of NOT LIKE. im using VB 2008 and SQL 2005. in one of my reports i use these code to show all employees with positon starting witn ADMIN.... the code is these: strWhere = "{qryInvent.SG} 23 AND {qryInvent.CurPosition} LIKE '*CM*'" now i want to show the opposite..the NOT LIKE but these syntax do not run. here is the code just opposite of the one above. strWhere = "{qryInvent.SG} 23 AND {qryInvent.CurPosition} NOT LIKE '*CM*'" i think the syntax is wrong. please help me.thanks