Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLStringMBS class.

SQLStringMBS.Empty

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Forces a string to have 0 length.

SQLStringMBS.GetBinaryLength as UInt32   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used. You can use BinaryLength instead.
Returns a count of the bytes in the binary data buffer.

Deprecated. Please use BinaryLength property.

SQLStringMBS.GetLength as UInt32   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used. You can use Length instead.
Returns the number of characters in a SAString object.

Deprecated. Please use Length property.
For multibyte character sets, GetLength counts each 8-bit character; that is, a lead and trail byte in one multibyte character are counted as two bytes.

SQLStringMBS.Left(count as Integer) as SQLStringMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Extracts the left part of a string.

SQLStringMBS.MakeLower

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Changes all characters in the string to lower case.

Some examples using this method:

SQLStringMBS.MakeUpper

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Changes all characters in the string to upper case.

Some examples using this method:

SQLStringMBS.Mid(first as Integer) as SQLStringMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Extracts the middle part of a string.

first: The zero-based index of the first character in this string object that is to be included in the extracted substring.

See also:

SQLStringMBS.Mid(first as Integer, Count as Integer) as SQLStringMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Extracts the middle part of a string.

first: The zero-based index of the first character in this string object that is to be included in the extracted substring.
count: The number of characters to extract from this string object. If this parameter is not supplied, then the remainder of the string is extracted.

See also:

SQLStringMBS.Operator_Convert as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Convert operation for assignment to string.

See also:

SQLStringMBS.Operator_Convert(text as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Convert operation for assigning text string.

See also:

SQLStringMBS.Right(count as Integer) as SQLStringMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Extracts the right part of a string.

SQLStringMBS.TrimLeft

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Trim leading whitespace characters from the string.

Some examples using this method:

SQLStringMBS.TrimRight

Type Topic Plugin Version macOS Windows Linux iOS Targets
method SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Trim trailing whitespace characters from the string.

Some examples using this method:

The items on this page are in the following plugins: MBS SQL Plugin.


The biggest plugin in space...