in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 8089 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
select * from Emp where name like '%j%'
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is indexed view?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is the current pricing model of SQL Azure?
What is Service Broker in sql server 2012?
what is the information that can be stored inside a bit column? : Sql server database administration
Is it true, that there is no difference between a rule and a check constraint?
What is difference between stored procedure and user defined function?
How to use clusters?
What is shrink log file?
How to convert character strings into numeric values?
How to use subqueries in the from clause in ms sql server?
how to invoke a trigger on demand? : Sql server database administration
How to list all columns in a table using odbc_columns()?
How to enter date and time literals in ms sql server?
