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 replace and stuff function in sql server?

996

What are the steps to process a single select statement?

887

What are the differences between DDL, DML and DCL in SQL?

1169

How do you Implement SSIS Packages in your Project?

1869

What is the difference between nvl and nvl2?

897

What is table-valued sub query?

920

What is the chart in report?

144

How to update a field in SQL after ALTERING a row?

1182

What is the difference between stored procedure and user defined functions?

1127

How do I edit a procedure in sql server?

897

What is the usage of the sign function?

997

Explain the first normal form(1nf)?

966

What are points to remember while using the fillfactor argument?

906

Can a rule be bound to any column of any data type?

910

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

887