What keyword does an SQL SELECT statement use for a string
search?

Answer Posted / sunil1405

SELECT FNAME WHERE FNAME LIKE 'S%';

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

585


Which are the db2 tools to protect integrity of the database?

692


What is the function of logging in the db2 database?

645


How do I change the column size in db2?

593


Who uses db2?

576






What is phantom read in db2?

638


What is a db2 tablespace?

602


What is a db2 table?

597


How do I delete a table in database?

599


What is check constraint. Explain with example.

648


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

628


Why do chiropractors use drop table?

662


How to find the number of rows in db2 tables?

617


Which command is used to remove all rows from a table?

553


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3120