Aug 14, 2025 · If either the expressionToFind or expressionToSearch expression has a Unicode data type (nchar or nvarchar), and the other expression doesn't, the CHARINDEX function …

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

Aug 15, 2025 · 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 …

Aug 15, 2025 · 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 …

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 …

Aug 15, 2025 · CHARINDEX Führt Vergleiche basierend auf der Eingabesortierung aus. Verwenden Sie COLLATE zum Ausführen eines Vergleichs in einer angegebenen Sortierung …

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') …

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

Apr 25, 2024 · Whereas Microsoft Excel has multiple versions of the FIND function to accommodate single-byte character set (SBCS) and double-byte character set (DBCS) …

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 …