Did you look in the direction of %Stream.GlobalCharacterSearchable?
See also Scalar Functions and Streams
SELECT Notes Stream,DATALENGTH(Notes) lenStream,SUBSTRING(Notes,DATALENGTH(Notes)-9) AS StreamLast10Chars FROM Sample.Employee WHERE Notes IS NOT NULL
- Log in to post comments