What is the SQL Server equivalent to Access InStr() function?
TargetField: String expression being searched
SearchValue: String expression being sought
StartPosition: Starting position for each search (optional)
Access SQL
InStr(TargetField, SearchValue)InStr(StartPosition, TargetField, SearchValue)
SQL Server
CHARINDEX(SearchValue, TargetField)CHARINDEX(SearchValue, TargetField, StartPosition)