How is the SUBSTR keyword used in SQL?

COBOL SQL Interview Questions

(Continued from previous question...)

How is the SUBSTR keyword used in SQL?

SUBSTR is used for string manipulation with column name, first position and string length used as arguments. E.g.
SUBSTR(NAME, 13) refers to the first three characters in the column NAME.

(Continued on next question...)

Other Interview Questions

• What is the difference between group by and order by ?
• What is meant by null?
• What are aggregate functions?
• What is an alias and how does it differ from a synonym?
• What is an object?
• What is the difference between group by and order by ?
• What is the difference between static and dynamic SQL?
• When is it necessary to create a table index?
• What is normalization and what are the five normal forms?
• What is a foreign key?
• More...