Kbase P185461: SQL: How to CREATE an SQL VIEW using the SUBSTRING function?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/04/2011 |
|
Status: Unverified
GOAL:
SQL: How to CREATE an SQL VIEW using the SUBSTRING function?
GOAL:
Can SQL views be created using a SUBSTRING of the database table(s) field(s)?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Yes, an SQL VIEW may be created using SUBSTRING of the underlying database table(s) field(s). For example, the following SQL script demonstrates how to CREATE an SQL VIEW using the SQL SUBSTRING function:
CREATE VIEW myView
( myName, myCity, myCountry, myComments )
AS
SELECT
Substring(Name, 1, 10),
Substring(City, 1, 8),
Substring(Country, 1, 5),
Substring(Comments, 1, 25)
FROM PUB.Customer