select * from employee where name like=%'j'% Thanx Ashok

in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Question Posted / ashok

Answer Posted / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain time data type in sal server 2008?

714

Explain how would you store your query in an SSRS report or a Database server?

102

explain different types of cursors? : Sql server database administration

751

How do you identify a foreign key?

775

What are the different type of replication in sql server?

737

How to list all field names in the result set using mssql_field_name()?

672

Suggest a method of joining two tables.

809

How to provide values to stored procedure parameters in ms sql server?

717

what types of replication are supported in sql server? : Sql server database administration

656

Why union all is faster than union?

676

Do you know query execution plan?

764

What is a non-clustered index?

716

What is the use of toad or sqldbx.?

885

What guidelines should be followed to help minimize deadlocks?

686

What is exclusive locks?

702