Answer / sunil1405

SELECT FNAME WHERE FNAME LIKE 'S%';

Answer / kirtish srivastava

Like is used with where clause to search,update, and delete a record using wild cards.

Example:-
To Search;-

select * from Employee where Name like 'a%'

Note;- Search all records whose employee name is stared from a character.

To Update:-

update Employee set Name='amit' where Name like 'a%'

update all records with name amit whose employee name is started from a character.

To Delete:-

delete from Employee where Name like 'a%'

Delete all records whose employee name is started from a Character.

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

What is db2 purescale?

0 Answers  

---

What is db2 connect?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

What is the use of with ur in db2?

0 Answers  

---

What is reorg in database?

1 Answers  

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

What is the function of the Data Manager?

2 Answers  

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

Name some fields from SQLCA

1 Answers  

---

What are concurrency issues?

0 Answers  

---