COMPUSPEC
| Strip off a leading '.' from the string | Output |
|---|---|
| select substring( '.FTSE', patindex( '.%', '.FTSE' ) + 1, 99 ) | FTSE |
| select substring( 'ROG.EU', patindex( '.%', 'ROG.EU' ) + 1, 99 ) | ROG.EU |
| select substring( NULL, patindex( '.%', NULL ) + 1, 99 ) | NULL |
|
|
Roger Hall COMPUSPEC |
|