select * from Emp where name like '%j%'

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

List the different types of collation sensitivities in sql server?

1079

Where are stored procedures in sql server?

1129

Define candidate key, alternate key, and composite key.

969

How do you size a resultset?

970

What is a rownum?

1063

How to create new tables with "select ... Into" statements in ms sql server?

1051

How to execute stored procedure in select statement sql server?

1114

What are scalar functions in sql?

1210

Define ACID properties in a Database?

1106

What are the 3 types of schema?

1178

Can we write trigger for view?

1071

Do you have any idea about the tcl commands?

1016

How to start sql server browser service?

1183

Explain about the command-line tool SQLCMD?

1147

What is difference between cte and view?

979