Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
Not like query in sql server in Queries of SQL Queries
4097 Views
Hints 
"not like" used in where condition with column and values.Opposite to this "like" also available.

In following example, select emp_no where the enter date other than 1998.If you use like and not like read about wildcards in sql. Example %,_ for different purpose different wilcards are available.
Syntax
select columnName from tableName where columnName not like 'value';

/*select the column where the value not like given value.*/
Example
Get the employee numbers for all employees who didn’t enter their project in 1998

select emp_no from Works_on where enter_date not like '1998%';
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details