Aug 14, 2025 · CHARINDEX performs comparisons based on the input collation. To perform a comparison in a specified collation, use COLLATE to apply an explicit collation to the input.

如果 expressionToFind 或 expressionToSearch 運算式具有 Unicode 資料類型 （nchar 或 nvarchar），而另一個運算式沒有， CHARINDEX 則函式會將該其他運算式轉換成 Unicode …

CHARINDEX realiza comparaciones basadas en la intercalación de entrada. Para realizar una comparación en una intercalación especificada, use COLLATE para aplicar una intercalación …

CHARINDEX executa comparações com base na ordenação de entrada. Para executar uma comparação em uma ordenação especificada, use COLLATE para aplicar uma ordenação …

May 23, 2023 · String Functions (Transact-SQL)All built-in string functions except FORMAT are deterministic. This means they return the same value any time they are called with a specific …

如果 expressionToFind 或 expressionToSearch 表达式具有 Unicode 数据类型（nchar 或 nvarchar），而其他表达式则不，则 CHARINDEX 函数会将该其他表达式转换为 Unicode 数 …

Jul 21, 2025 · position -------- 8 PATINDEX works just like LIKE, so you can use any of the wildcards. You don't have to enclose the pattern between percents. PATINDEX('a%', 'abc') …

CHARINDEX Führt Vergleiche basierend auf der Eingabesortierung aus. Verwenden Sie COLLATE zum Ausführen eines Vergleichs in einer angegebenen Sortierung eine explizite …

Nov 10, 2022 · CHARINDEX will return 0 if no '-' are in the string and then you look for a substring of **0 - 2 = -2 ** length. Therefore, you'd better check if there is any special data in the source …

Mar 30, 2022 · Note Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model. Office Add-ins have a small …