String Expressions (M to SQL Mapping)

[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.]

String expressions are translated as follows.

Operator	“M” Example	SQL Example
Count	A# A.Count	LEN(A)
Concatenation	A + B	A + B
Comparison	A < B A <= B A > B A >= B A == B A != B	A < B A <= B A > B A >= B A = B A <> B
Like	A.Like(B)	Not currently implemented
PatternIndex	A.PatternIndex(B)	Not currently implemented