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 are the various security methods which IIS Provides apart from .NET ?

1 Answers  

---

How does windows service lifecycle differ from a .standard. Exe?

0 Answers  

---

What is the usie of activex control in .net?

0 Answers  

---

which method marks a config file section for encryption?

1 Answers  

---

What is Web API?

0 Answers  

---

Mention the execution process for managed code?

0 Answers  

---

what is session,cokkies in asp.net??

5 Answers  

---

Can a .net web application consume java web service?

0 Answers  

---

What is Master Page in Asp.net?

9 Answers  

---

Is a dll file an executable?

0 Answers  

---

can s/w quality assurance engineer switch field to programming side i m very much interested in programming but not much good in it

0 Answers  

---

Tell About Global.asax ?

3 Answers   Keane India Ltd,

---