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...

How is the SUBSTR keyword used in sql?

Answer Posted / s

Select * from emp
where SUBSTR(empname,4,2) = 'EN'

4 is the starting position and returns 2 characters after
that.

Is This Answer Correct ?    8 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is host variable?

1011


Explain the benefits you can get from mainframe connect?

908


What is the use of reorg in db2?

1021


What are union and union all?

920


What is release/acquire in bind?

1054


What is db2 purescale?

938


Mention the definition of cobol in varchar field.

1176


What do you mean by cursor?

942


How to test SQL -911 error while developing COB-DB2 program

7436


B37 abend during spufi?

1403


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2019


What is the latest version of ibm db2?

1197


List out the three types of page locks that can be held.

1090


Which components manage deadlocks in db2?

1011


What is runstats utility in db2?

961