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 do I connect to sql server database?

950

What is query cost in sql server?

934

How to optimize stored procedures in sql server?

1121

What are rest-style architecture's?

170

What is a partitioned view?

948

How can you hide the sql server instances?

975

Can you explain what is the use of custom fields in report?

999

Can you explain full-text query in sql server?

969

explain different levels of normalization? : Sql server database administration

928

define and explain the differences between clustered and non-clustered indexes.

1118

How column data types are determined in a view?

897

What command is used to create a database in the sql server and how?

1112

When does a workload on SQL Azure get throttled?

129

What is indexed view? How to create it?

930

How do you start single user mode in clustered installations?

901