Sybase patindex function

Code	Output
select patindex( '%.EU', 'ROG.EU' )	4
select patindex( '%.%', 'ROG.EU' )	4
select patindex( '%[ABCDE]%', 'ROG.EU' )	5
select patindex( '%.', 'ROG.EU' )	0
select patindex( '.%', 'ROG.EU' )	0
select patindex( '.%', '.FTSE' )	1
select patindex( '.FTSE', '.FTSE' )	1
select patindex( NULL, '.FTSE' )	0
select patindex( '.FTSE', NULL )	0

Roger

Roger Hall
COMPUSPEC