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

is it compulsory commitment control in journal?

2484


Are view updateable?

1051


Explain the benefits you can get from mainframe connect?

975


What is the difference between bind and rebind in db2?

1459


Define sqlca.

1119


What is image copy in db2?

1023


What is a dbrm in db2?

1032


What is dbrm? When it will be created?

1034


What is ibm db2 database?

1016


Who uses db2?

1057


What is a buffer in memory?

1066


What is the difference between oracle and db2?

1118


How do you concatenate the firstname and lastname from emp table to give a complete name?

1077


What is buffer pool?

1110


What is bind and rebind in db2?

1142