enrique_aeo
asked on
CHARINDEX with start_location
do not understand why the result is the same if the difference is in the parameter start_location
charINDEX.jpg
charINDEX.jpg
Because all the start position parameter does is tell SQL Server, "ignore any instances of the substring that start before ".
ASKER
i do not understand very well
i confuse because msdn tell
Is an integer or bigint expression at which the search starts. If start_location is not specified, is a negative number, or is 0, the search starts at the beginning of expression2.
i confuse because msdn tell
Is an integer or bigint expression at which the search starts. If start_location is not specified, is a negative number, or is 0, the search starts at the beginning of expression2.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
your example is much better. Thanks