INStr equivalent in SQL Server 2008

I use the instr function in VB all the time and wanted to do something similar in a SQL Server query.
I found that charindex(searchstring,searchfield) does the trick.