in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answers were Sorted based on User's Feedback
Answer / muthu kumar
select * from emp where empname like '%j%'
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / deepa
For those who names starts with letter J is
select * from emp where name like 'j%'
For those who names with letter J is
select * from emp where name like '%j%'
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / faridha
select * from emp where ename like 'J%' or '%J' and
not like ('arjun','jagadesh','niranjan','anju','aaaj');
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
Is This Answer Correct ? | 1 Yes | 7 No |
Answer / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
Is This Answer Correct ? | 0 Yes | 7 No |
Tell me what do we need queues in sql service broker?
How do I find the default sql server instance?
can we call functions from stored procedure in SQL Server 2005 ? How?
What language is sql server written in?
How to execute the cursor queries with "open" statements?
which one will take 1st priority in case of insert statement and select statement???
Do you know what are acid properties of transaction?
Please differentiate between a local and a global temporary table?
What is multilevel indexing?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
Define DML and DCL statements?