Function equivalents

Those pesky dialects! Here are some equivalent functions in various languages.

Language Syntax Notes
Find the first occurrence of one string in another string
C# haystack.IndexOf(needle); Returns zero-indexed offset
Excel =FIND(needle, haystack[, offset]) Case sensitive, offset indexed from 1
PHP strpos(haystack, needle); Returns zero-indexed offset
SSIS expressions FINDSTRING(haystack, needle, offset) offset indexed from 1
TSQL CHARINDEX(needle, haystack[, offset]) offset indexed from 1
Replace one substring with another in a containing string
Excel =SUBSTITUTE(haystack, needle, new_needle[, occurrence_num]) Case-sensitive. occurrence_num specifies which occurrence to replace; default is all.
TSQL REPLACE(haystack, needle, new_needle) Replaces all occurrences
Replace a portion of a string with a new string
Excel =REPLACE(haystack, offset, num_chars, new_needle) offset indexed from 1. Insert one string into another by replacing 0 characters at offset
TSQL STUFF(haystack, offset, num_chars, new_needle) offset indexed from 1. Insert one string into another by replacing 0 characters at offset
Generate a string by repeating another one a number of times
Excel =REPT(string, number_of_times)
TSQL REPLICATE(string, number_of_times)