Breaks a CHAR string into terms and returns each term as a row along with its position.
sa_char_terms( 'char-string' [, 'text-config-name' [, 'owner' ] ] ] )
char-string The CHAR string you are parsing.
text-config-name The text configuration object to apply when processing the string. The default value is 'default_char'.
owner The owner of the specified text configuration object. The default value 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.
None
None
The following statement returns the terms in the CHAR string 'the quick brown fox jumped over the fence':
CALL sa_char_terms ( 'the quick brown fox jumped over the fence' ); |
term | position |
---|---|
the | 1 |
quick | 2 |
brown | 3 |
fox | 4 |
jumped | 5 |
over | 6 |
the | 7 |
fence | 8 |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |