Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers. It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.
They both return bigint's that are the starting values.
Declare @str varchar(100) = 'abcdefghigklmnopqrstuvwxyz_e' /* CHARINDEX http://msdn.microsoft.com/en-us/library/ms186323.aspx Searches an expression for another expression and returns its starting position if found. */ -- Select the first e in a string SELECT CHARINDEX('ef', @str) -- Select the first e in a string, starting at the 10th character SELECT CHARINDEX('e', @str, 10) /* PATINDEX http://msdn.microsoft.com/en-us/library/ms188395 Turns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types. */ SELECT PATINDEX('%efg%', @str)
Join the community of 500,000 technology professionals and ask your questions.