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";