in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Tell me what is use of except clause? How it differs from not in clause?
How dts is used to extract, transform and consolidate data?
What are locks in sql?
What is the order by used for?
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? : Sql server administration
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Can a synonym name of a table be used instead of a table name in a select statement?
What are “lost updates”?
After removing a table from database, what other related objects have to be dropped explicitly?
What are logical database components? : SQL Server Architecture
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is self contained scalar sub query?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is a trace frag?