There also exist algebraic operators (+, -, *, /) to perform string concatenation and deletion.
Example
SELECT "Hello"+"World" FROM Stream => "HelloWorld" SELECT "HelloWorld"-"World" FROM Stream => "Hello" SELECT "HelloWorld"*3 FROM Stream => "HelloWorldHelloWorldHelloWorld" SELECT "HelloWorldHelloWorldHelloWorld"/"World" FROM Stream => 3
Concat(String, String)
Returns a new string that is a concatenating the arguments.
SubString(String, Begin, End)
Returns a new string that is a substring of the value with given begin and end index
Length(String)
Returns the length of a string.
Upper(String)
Returns the string converted to uppercase.
Lower(String)
Returns the string converted to lowercase.