Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Breaks an NCHAR string into terms and returns each term as a row along with its position.
sa_nchar_terms( 'text' [, 'config_name' [, 'owner' ] ]
The NCHAR string you are parsing.
The text configuration object to apply when processing the string. The default is 'default_nchar'.
The owner of the specified text configuration object. The default is DBA.
You can use this system procedure to find out how a string is interpreted when the settings for a text configuration object
are applied. This can be helpful when you want to know what terms would be dropped during indexing or from a query string.
The following statement returns the terms in the CHAR string, It's a work-at-home day!, using the default CHAR text configuration
CALL sa_nchar_terms (N'It''s a work-at-home day!', 'default_nchar', 'sys');