Instr() Equivalent in SQL Server Jul 20 '05, 01:23 AMI am trying to convert a complex function from Oracle to SQL Server and have come across Oracle's Instr() function. I see SQL Server has CHARINDEX() which is similar, however it does not provide some key ...
The SQL INSTR function allows you to find the starting location of a substring within a string. It is used by Oracle SQL and MySQL; many other SQL implementations have functions which are the exact or near equivalent. It’s worth you while to get acquainted with basic SQL functions such as...