Search

Saturday, December 31, 2011

CHARINDEX function returns the starting position in a character string

To get the starting position of a character that you might be looking, there is in SQL a function called CHARINDEX that will give you just that.

Example:

SELECT CHARINDEX(' ', [ContactName]) AS PositionOfWSInContactNameFROM [Northwind].[dbo].[Customers]This will return to you the position where the white space begins in a column.

The Syntax is:

CHARINDEX ( expression1 , expression2 [ , start_location ] )

expression1 - An expression that contains the sequence of characters to be found
expression2 - An expression that is typically a column searched for the specified sequence
start_location - Not necessary - The character position from which to start searching forexpression1 in expression2. If start_location is not given, is a negative number, or is 0, the search starts at the beginning of expression2.

No comments:

Post a Comment