sa_nchar_terms system procedure

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

text The LONG NVARCHAR string you are parsing.
config_name Use this optional CHAR(128) parameter to specify the text configuration object to apply when processing the string. The default is 'default_nchar'.
owner Use this optional CHAR(128) parameter to specify the owner of the text configuration object. The default value is NULL. The current user is assumed if the owner is not specified or if NULL is specified.

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

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

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

term	position
It	1
s	2
a	3
work	4
at	5
home	6
day	7

sa_nchar_terms system procedure

Syntax

Arguments

Remarks

Privileges

Side effects

See also

Example