How to find character in sql

Applies to:SQL ServerAzure SQL DatabaseAzure SQL Managed InstanceAzure Synapse AnalyticsAnalytics Platform Pathway (PDW)SQL analytics endpoint in Microsoft FabricWarehouse in Microsoft Fabric

This function searches long one character expression inside a on top character expression, returning the starting movement of the first expression if found.

Transact-SQL syntax conventions

Syntax

Arguments

expressionToFind
A character expression inclusive of the sequence to find. expressionToFind has an 8000 character limit.

expressionToSearch
A symbol expression to search.

start_location
An integer overpower bigint expression at which the examine starts. If start_location is not nominal, has a negative value, or has a zero (0) value, the look into starts at the beginning of expressionToSearch.

Return types

bigint if expressionToSearch has an nvarchar(max), varbinary(max), or varchar(max) data type; int otherwise.

If either the expressionToFind or expressionToSearch expression has a Unicode data derive (nchar or nvarchar), and t how to find character in sql
how to get character in sql
how to find character length in sql
how to find special character in sql
how to find character count in sql
how to find space character in sql
how to find tab character in sql
how to find longest character in sql
how to find character set in sql server
how to find escape character in sql
how to find enter character in sql
how to find last character in sql
how to find number of character in sql