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

How to sort the query output with order by clauses in ms sql server?

1072

What is user-defined multi-statement table-valued function?

1120

What do you mean by sql server 2005 express management tools?

1358

What is the difference between NOROW and LOCKROW?

2900

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1054

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2116

explain different types of joins? : Sql server database administration

1035

What is dbcc updateusage?

1258

Explain the database you used in your final year project?

1107

Can you name some of the dml commands in sql?

1085

What are the different types of sql server replication? : sql server replication

1368

What is db stored procedure?

945

How to create new databases with "create database" statements?

1067

What is federation member?

116

How do use Having,Group by,Group function in SQL?

1789