Answer / sharifuddin

for this first design the table like the fields as

EMPNo | EMPNAME | SALARY | DETAILS

Now write the query as follows...

SELECT * FROM EMPLOYE WHERE DETAILS LIKE '%<SEARCH KEY>%'

This is the simplest query for that...

Sharif

Answer / mahendra

note that, when datatype is string i.e. details like
mahendra, then use like this - "select * from employee
where empname like '%" & trim(txtbob.text) "&' ", i used
because to any leading space will be deleted.

if u want to find salary figure that i integer then
"select * from employee where salary >= " & trim
(txtbob.text) "&"

pl.note '%" & '&" for string


for this first design the table like the fields as

EMPNo | EMPNAME | SALARY | DETAILS

Now write the query as follows...

SELECT * FROM EMPLOYE WHERE DETAILS LIKE '%<SEARCH KEY>%'

This is the simplest query for that...

What is the use of directives & explain with example?

2 Answers   C Squared Systems,

---

How can you use a custom controls in ASP.NET application?

0 Answers   Sans Pareil IT Services,

---

Why is mvc better than asp.net?

0 Answers  

---

what is <location> tag?

2 Answers  

---

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

2 Answers  

---

what is value type to reference type

6 Answers   AG Technologies, IBM,

---

What is stateless asp or asp.net ?

2 Answers   Accenture, BirlaSoft,

---

How can you handle errors in Web API?

0 Answers  

---

What is AutoEventWireup attribute for ?

0 Answers  

---

What is viewstate?

5 Answers   Microsoft,

---

What are main return types supported in Web API?

0 Answers  

---

If you want to write your own dot net language, what steps you will you take care?

0 Answers  

---