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

How is the SUBSTR keyword used in sql?

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

Is db2 free?

1099

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

7102

List down the data types in the db2 database.

1128

What is db2 connect?

1078

What is explain in db2?

1033

What is db2 optimizer?

1249

How do you select a row using indexes in db2?

1138

Who uses db2?

1054

What is the role of schema in the db2 database?

1278

What is a db2 table?

1022

What is the physical storage length of date data type?

1256

What are the prerogatives?

1083

What are foreign keys in db2?

1108

Mention the various locks that are available in db2.

1043

What is multi row fetch in db2?

1052