COMPUSPEC
| Code | Output | |
|---|---|---|
| 11.9.2 | 12.5.3 | |
| select char_length( 'Roger' ) | 5 | 5 |
| select char_length( 'R' ) | 1 | 1 |
| select char_length( ' ' ) | 1 | 1 |
| select char_length( '' ) | 1 | 1 |
| select char_length( NULL ) | NULL | NULL |
| select char_length( replicate( '1234567890', 100 ) ) | 250 | 1000 |
| select char_length( replicate( '1', 1000 ) ) | 255 | 1000 |
| select char_length( 5 ) | Error | Error |
|
|
Roger Hall COMPUSPEC |
|