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

How you can change a cross join into an inner join?

622

Can group functions be mixed with non-group selection fields in ms sql server?

620

How do I view a procedure in sql server?

628

How to use group functions in the select clause in ms sql server?

614

How to make a remote connection in a database?

603

What is the difference between TRUNCATE and DROP?

711

where the connection string store in the database

1626

What according to you is the difference between mysql and sql server performance?

653

How you can get a list of all the table constraints in a database?

593

How to retrieve error messages using mssql_get_last_message()?

625

What is a trigger and its types?

635

What is merge?

644

Mention the different authentication modes in sql server.

616

Explain Geometry datatype in sql server 2008 with example

673

Can we call future method from trigger?

602