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)
- InStr(TargetField, SearchValue)
- InStr(StartPosition, TargetField, SearchValue)
- CHARINDEX(SearchValue, TargetField)
- CHARINDEX(SearchValue, TargetField, StartPosition )
No comments:
Post a Comment