Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
There also exist algebraic operators (+, -, *, /) to perform string concatenation and deletion.
Code Block | ||||
---|---|---|---|---|
| ||||
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,
BeginNumber,
EndNumber)
Returns a new string that is a substring of the value with given begin and end index
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT substring("Hello World",1,3) FROM Stream
=> "el" |
Length(String)
Returns the length of a string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT length("Hello") FROM Stream
=> 5 |
Upper(String)
Returns the string converted to uppercase.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT upper("Hello World") FROM Stream
=> "HELLO WORLD" |
Lower(String)
Returns the string converted to lowercase.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT lower("Hello World") FROM Stream
=> "hello world" |
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT substring("Hello World",1,3) FROM Stream
=> "el" |
Table of Contents |
---|