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 create a stored procedure in sql server?

1010

what is a sub-report?

140

Where sql server usernames and passwords are stored in a sql server?

969

Explain collation?

1048

How connect excel to sql server?

969

What is the main difference between ‘between’ and ‘in’ condition operators?

1162

Is it possible to have clustered index on separate drive from original table location?

944

What are transactions and its controls?

1042

What are the properties and different types of sub-queries?

990

How to populate a table in sql server?

935

What is the difference between truncate and delete commands?

1042

What do you mean by 'normalization'?

1040

How to create new table with "create table" statements?

1063

What is BCP? When does it used in sql server 2012?

1042

What are the underflow and overflow behaviors on float literals?

1098