substr('string',1,3) which gives str. correct me if i am wrong

Write a query to retrive partial string.

Question Posted / rajesh_m13

Answer Posted / rajesh_m13

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1065

What is the maximum size of varchar data type in db2?

1134

What is cloudant database?

1096

can all users have the privilage to use the sql statement select * (dml)?

1168

What types of tables are there in the db2 database?

1057

Explain about dbrm.

1047

Define predicate?

1131

How do you select a row using indexes in db2?

1135

How can record locking be achieved in those DB2 versions which do not support it?

1076

What does db2 blu stand for?

1165

How to find the maximum value in a column in the db2 database?

1083

What is data manager?

1049

How would the varchar column remarks defined?

1088

What is check constraint in db2?

1087

What is schema in db2?

1021