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 does db2 stand for?

0 Answers  

---

How does db2 sample database connect?

0 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is dynamic SQL?

1 Answers   ADP,

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

What are the two types of logging in the db2 database? Explain them.

0 Answers  

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  

---

What does db2 mean?

0 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is db2 look?

0 Answers  

---

Update command

1 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---