Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Write a query to retrive partial string.

Answer Posted / ignatius pradeep

A Sample Query:

SELECT SUBSTR(DESC_T,1,4)
FROM PRODUCT
WHERE PROD_I = 123456;

DESC_T is a column in the table PRODUCT

The first four characters of the DESC_T will be displayed.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1053


What is sqlca’s maximum length?

1153


What is copy pending and check pending in db2?

986


What is cobol db2?

982


What r the comman abends in db2, jcl and cobol???????

2242


How do I optimize a query in db2?

1081


Discuss about db2 bind?

1079


Can we delete records from view?

953


Explain the function of data manager.

1031


Explain about dbrm.

1030


What does runstats do in db2?

1083


What is dbrm? What it contains? When it will be created?

1032


What are db2 tables?

1097


When do you specify the isolation level?

1015


Define buffer pool.

1034