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 can we delete a table in sql server?

979

what is unique and xaml nonclustered index

1051

What is the maximum size of sql server database?

1012

What are types of subqueries?

1071

How to update multiple rows with one update statement in ms sql server?

1209

What does Master database contains?

1140

What are drilldown reports?

156

how you can get the list of largest tables in a database? : Sql server administration

1054

Do you know clustered and non-clustered index?

979

How does clustered and non clustered index work?

927

When do you think a developer should use sql server-based cursors?

1052

What is the difference between stored procedure and functions?

1137

Mention the uses of stored procedures.

972

Explain index in sql server?

1021

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1270