Breaks an NCHAR string into terms and returns each term as a row along with its position.
sa_nchar_terms( 'char-string' [, 'text-config-name' [, 'owner' ] ] ] )
char-string The NCHAR string you are parsing.
text-config-name The text configuration object to apply when processing the string. The default is 'default_nchar'.
owner 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 syntax for this system procedure is similar to the sa_char_terms system procedure. See the Example section in sa_char_terms system procedure.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|