Example and Notes
Use this SQL Server example as a starting point for development, troubleshooting, reporting, or maintenance work. Review it against your schema, data volume, permissions, and SQL Server version before using it in production.
The CharIndex function is very useful for getting the first or starting location of an expression or characters in a given string. Sometimes you need to find where a specific string or character starts in an string. This sample script will show you how to accomplish this. For more details on the CHARINDEX function click here
Select CustomerName, CHARINDEX('Golf',CustomerName)
From tblCustomers
Where CustomerName Like '%golf%'
Production Review
WSI can adapt this script for your database, improve error handling, tune performance, document the logic, and help deploy it safely.