You cannot combine like and in. The statement below would do the job though:
Select * from Table1 where EmpPU NOT Like '%CSE%' AND EmpPU NOT Like '%ECE%' AND EmpPU NOT Like '%EEE%'
Related Posts:
- T-SQL split string
- How can I get column names from a table in SQL Server?
- Inserting multiple rows in a single SQL query? [duplicate]
- How to delete duplicate rows in SQL Server?
- T-SQL split string based on delimiter
- How do I perform an IF…THEN in an SQL SELECT?
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- SQL Server : Arithmetic overflow error converting expression to data type int
- How to calculate percentage with a SQL statement
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- Query error with ambiguous column name in SQL
- How can I delete using INNER JOIN with SQL Server?
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- How to group by month from Date field using sql
- Is there a combination of “LIKE” and “IN” in SQL?
- MS SQL compare dates?
- MS SQL compare dates?
- Using RegEx in SQL Server
- How to format a numeric column as phone number in SQL
- sql query to return differences between two tables
- SQL: IF clause within WHERE clause
- Can I use multiple “with”?
- How can I group by date time column without taking time into consideration
- Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
- How to select the last record of a table in SQL?
- Comma separated results in SQL
- Varchar invalid for Sum operator
- Selecting COUNT(*) with DISTINCT
- What is a stored procedure?
- Self Join to get employee manager name
- SQL query to select dates between two dates
- When should I use CROSS APPLY over INNER JOIN?
- SQL query to get the employee name and their manager name from the same table
- How can I do an UPDATE statement with JOIN in SQL Server?
- Rename column SQL Server 2008
- Efficiently convert rows to columns in sql server
- How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
- The SQL OVER() clause – when and why is it useful?
- Update multiple columns in SQL
- How do I escape a single quote in SQL Server?
- SQL Server IF EXISTS THEN 1 ELSE 2
- How do I escape a single quote in SQL Server?
- IDENTITY_INSERT is set to OFF – How to turn it ON?
- SQL update from one Table to another based on a ID match
- An attempt was made to access a socket in a way forbidden by its access permissions
- Each GROUP BY expression must contain at least one column that is not an outer reference
- How to drop all tables from a database with one SQL query?
- Column name or number of supplied values does not match table definition
- How do I do multiple CASE WHEN conditions using SQL Server 2008?
- SQL Server FOR EACH Loop
- Delete all the records
- In SQL Server, what does “SET ANSI_NULLS ON” mean?
- How to drop all tables from a database with one SQL query?
- How to find sum of multiple columns in a table in SQL Server 2005?
- Invalid length parameter passed to the LEFT or SUBSTRING function
- Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
- Keeping it simple and how to do multiple CTE in a query
- Why use a READ UNCOMMITTED isolation level?
- SQL Server WITH statement
- Find all tables containing column with specified name – MS SQL Server
- DateTime2 vs DateTime in SQL Server
- SQL Server Insert if not exists
- CREATE TABLE IF NOT EXISTS equivalent in SQL Server
- SQL Server: Invalid Column Name
- SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
- How do I do multiple CASE WHEN conditions using SQL Server 2008?
- How to get a date in YYYY-MM-DD format from a TSQL datetime field?
- Search text in stored procedure in SQL Server
- What is the equivalent of ‘describe table’ in SQL Server?
- Error converting data type varchar to float
- Arithmetic overflow error converting numeric to data type numeric
- I want to use CASE statement to update some records in sql server 2005
- What represents a double in sql server?
- How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Sql query to insert datetime in SQL Server
- What is the maximum characters for the NVARCHAR(MAX)?
- Conversion failed when converting the varchar value ‘simple, ‘ to data type int
- SELECT DISTINCT on one column
- TSQL PIVOT MULTIPLE COLUMNS
- Microsoft OLE DB Provider for SQL Server error ‘80004005’
- Bulk load data conversion error (truncation)
- Equivalent of Oracle’s RowID in SQL Server
- How do I format a number with commas in T-SQL?
- Get current year in TSQL
- Is it possible to specify condition in Count()?
- SQL Server dynamic PIVOT query?
- Backup a single table with its data from a database in sql server 2008
- Error converting data type varchar
- Temporary table in SQL server causing ‘ There is already an object named’ error
- I want to use CASE statement to update some records in sql server 2005
- To add server using sp_addlinkedserver
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- how to increment integer Columns value by 1 in SQL
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- SQL- Ignore case while searching for a string
- SUM OVER PARTITION BY
- Filter data based on date in sql
- How to count instances of character in SQL Column
- What is tableName.* in SQL