sa_nchar_terms( 'text' [, 'config_name' [, 'owner' ]  ]  
)

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

• Full text search
• How to manage text configuration objects
• sa_char_terms system procedure

The following statement returns the terms in the CHAR string, It's a work-at-home day!, using the default CHAR text configuration object, default_char:

CALL sa_nchar_terms (N'It''s a work-at-home day!', 'default_nchar', 'sys');