Posted by Roy Harvey on 10/02/93 11:52

On 29 Jun 2006 11:40:22 -0700, "sql guy123" <stoppal@hotmail.com>
wrote:

>Select field1, field2 FROM table1 Where left(field1,4)=left(field2,4)
>
>(MS SQL does not have left() and right() functions)

MS SQL Server does have both LEFT and RIGHT functions.

From the Books on Line for SQL Server 2000:

RIGHT
Returns the right part of a character string with the specified number
of characters.

Syntax
RIGHT ( character_expression , integer_expression )

Arguments
character_expression

Is an expression of character or binary data. character_expression can
be a constant, variable, or column. character_expression can be of any
data type (except text or ntext) that can be implicitly converted to
varchar or nvarchar. Otherwise, use the CAST function to explicitly
convert character_expression.

integer_expression

Is a positive integer that specifies how many characters of the
character_expression will be returned. If integer_expression is
negative, an error is returned.

Return Types
varchar or nvarchar


LEFT
Returns the left part of a character string with the specified number
of characters.

Syntax
LEFT ( character_expression , integer_expression )

Arguments
character_expression

Is an expression of character or binary data. character_expression can
be a constant, variable, or column. character_expression can be of any
data type (except text or ntext) that can be implicitly converted to
varchar or nvarchar. Otherwise, use the CAST function to explicitly
convert character_expression.

integer_expression

Is a positive integer that specifies how many characters of the
character_expression will be returned. If integer_expression is
negative, an error is returned.

Return Types
varchar or nvarchar.

Roy Harvey
Beacon Falls, CT

[Back to original message]