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

i want to maintain uniqueness on pdf without make lf??????????

2099


What is commit in db2?

998


How to execute stored procedures?

1068


define clustering index.

980


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1057


Is it possible to create an Instance in DB2 using DB2 Control Center ?

1045


Describe major components of db2?

1044


What is copy pending and check pending in db2?

954


What is package in db2 mainframe?

923


What is the max length of sqlca?

1160


My sql statement select avg(salary) from emp yields inaccurate results. Why?

1034


Which component is responsible for db2 startup and shutdown?

985


Which component is responsible for processing sql statements and selecting access paths?

1074


How can the duplicate values be eliminated from db2 select?

1044


What is host variable?

1016