COMPUSPEC
| Code | Output |
|---|---|
| select substring( 'ROG.EU', 1, 3 ) | ROG |
| select substring( 'ROG.EU', 4, 1 ) | . |
| select substring( 'ROG.EU', 5, 2 ) | EU |
| select substring( 'ROG.EU', 1, 9999 ) | ROG.EU |
| select substring( 'ROG.EU', -2, 5 ) | NULL |
| select substring( 'ROG.EU', 0, 5 ) | NULL |
| select substring( NULL, 0, 5 ) | NULL |
| select substring( 'ROG.EU', NULL, 5 ) | NULL |
| select substring( 'ROG.EU', 0, NULL ) | NULL |
| select substring( 'ROG.EU', 5, -1 ) | Error |
|
|
Roger Hall COMPUSPEC |
|