Interested to Buy Any Domain ? << Click Here >> for more details...
What keyword does an SQL SELECT statement use for a string
search?
- 2 Answers
- 8346 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is isolation level in db2?
Explain package in db2 and its advantages?
What is the maximum length of sqlca?
What is a cursor in programming?
Discuss about db2 bind?
Explain how can you do the explain of a dynamic sql statement?
What is ibm db2 client?
Which is faster delete or truncate?
Define buffer pool.
Is it possible using max on a char column?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is multi row fetch in db2?
Why db2 is called db2?
How does db2 sample database connect?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
