compare

Allows you to directly compare two character strings based on alternate collation rules.

Syntax

compare ({char_expression1|uchar_expression1}, 
	{char_expression2|uchar_expression2}), 
	[{collation_name | collation_ID}] 

Parameters

Examples

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute compare.