in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Answer Posted / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 2nf normalization form?

776


What are page splits? : SQL Server Architecture

744


How do I debug a stored procedure in sql server?

726


How to generate random numbers with the rand() function in ms sql server?

758


How can you fetch alternate records from a table?

710






What are the requirements to use odbc connections in php scripts?

803


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

713


What are the rendering extensions of ssrs?

125


Why do we use stored procedures in sql server?

677


How to create a login account in ms sql server to access the database engine using "create login" statements?

733


What is PROJECTION Operation?

765


How do use Having,Group by,Group function in SQL?

1533


What are different types of subquery?

908


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

764


What is an execution plan?

742