Text Type ("M" Reference)

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

The Text type encompasses any sequence of Characters.

Operators

The postfix operator in the following table takes Text as a left operand.

Operator	Return
#	Integer

The binary operators in the following table take Text as a left operand.

Operator	Right Operand	Return
+	Text	Text
>, <, <=, >=, ==, !=	Text	Logical

Functions

The functions in the following table are defined on Text.

Function	Description
Count()	Returns the number of Characters in the text.
Like (pattern : Text)	Returns true if the pattern is found within the Text, otherwise false.
PatternIndex (pattern : Text)	Returns the starting position of the pattern within the Text, or -1 if the pattern is not found.

Code Example

The following code shows the Employee field being declared as a Text type and receiving the value David Campbell.

Employee : Text = "David Campbell";