COMPUSPEC
| Code | Output | Notes |
|---|---|---|
| select charindex( '.', 'ROG.EU' ) | 4 | |
| select charindex( '.E', 'ROG.EU' ) | 4 | |
| select charindex( '%.EU', 'ROG.EU' ) | 0 | |
| select charindex( 'U', 'ROG.EU' ) | 6 | |
| select charindex( 'R', 'ROG.EU' ) | 1 | |
| select charindex( 'X', 'ROG.EU' ) | 0 | |
| select charindex( '', 'ROG.EU' ) | 0 | |
| select charindex( '', 'ROG EU' ) | 4 | |
| select charindex( ' ', 'ROG EU' ) | 4 | |
| select charindex( NULL, 'ROG.EU' ) | 0 | |
| select charindex( 'ROG.EU', NULL ) | 0 | |
| select charindex( 0xEE, 0xCCDDEEFF ) | 3 | |
| select charindex( 0xA, 0xCCDD0AFF ) | 3 | |
| select charindex( 3, 0x00000300 ) | 3 | |
| select charindex( NULL, NULL ) | NULL | |
| select charindex( 0x22, convert( int, 0x110022 ) ) | 3 | Platform Dependant ? |
| select charindex( 0x22, 285221376 ) | 3 | Platform Dependant ? |
|
|
Roger Hall COMPUSPEC |
|