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 ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the recovery model?

972

Detail about the hardware which is supported by SQL server?

1046

How to fine-tune reports?

264

what are the Prerequisites for Replication?

11324

What are data regions?

134

What are the different types of columns types constraints in the sql server?

1059

How can I create a new template for import ? : sql server management studio

1056

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2756

What is cursors? And what are the different types of cursor?

1127

What is the use of keyword with encryption.

1015

How can sql server instances be hidden?

928

Explain what are the authentication modes in sql server?

995

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

953

What do you understand by SQL*Net?

998

Explain about thread and memory management process of SQL?

957