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 / kalpana

Answer Posted / kalpana

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is SQL Azure?

105

What are the types of table?

915

What are the character string functions supported by sql server 2005?

933

Explain mixed authentication mode of sql server?

988

What happens if ntwdblib.dll is missing on your machine?

1097

What is buffer cash and log cache in sql server?

1051

What is the default Port No on which SQL Server listens?

1066

What objects does the fn_my_permissions function reports on? : sql server security

990

What is the need for group functions in sql?

1006

Does table partitioning improve performance?

899

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1095

What is resource governor in sql server?

947

Which is the latest version of sql server and when it is released?

1021

How to get the number of affected rows?

947

How to generate create procedure script on an existing stored procedure?

936