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

How do I add a column to a table in db2?

1093


can we view the access paths created by dbrm ? how ? thx

7054


Discuss about db2 bind?

1078


What is table space in db2?

1003


What is dclgen in db2?

1113


Where can you declare a cursor in a cobol-db2 program?

1055


What is nvl in db2?

1084


How to run db2 command in windows?

1175


Is the primary key a clustered index?

1122


What is db2 connect?

1048


Explain various types of locks in db2?

1124


Is schema the same as database?

1042


What is cursor with hold option in db2?

1052


Name the various locking levels available?

1081


What are the two types of logging in the db2 database? Explain them.

1055