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 ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain time data type in sal server 2008?

549

List all types of constraints in sql server?

511

How many instances per computer are there in sql server 2000?

578

User wants only to display only pdf as export option in report manager. How to achieve this?

173

What is database white box testing?

671

Explain steps of normalization?

525

How to return the top 5 rows from a select query in ms sql server?

586

How to list all schemas in a database?

578

How much memory that we are using in Logshipping Concept?

1366

Define clusters?

643

What is the difference RDBMS and Graph Database?

627

What is the impact on other user sessions when creating indexes?

536

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1401

What is explicit mode in sql server?

532

Explain the stored procedure?

633