You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 3 Next »
There also exist algebraic operators (+, -, *, /) to perform string concatenation and deletion.
SELECT "Hello"+"World" FROM Stream => "HelloWorld" SELECT "HelloWorld"-"World" FROM Stream => "Hello" SELECT "HelloWorld"*3 FROM Stream => "HelloWorldHelloWorldHelloWorld" SELECT "HelloWorldHelloWorldHelloWorld"/"World" FROM Stream => 3
Returns a new string that is a concatenating the arguments.
Returns a new string that is a substring of the value with given begin and end index
SELECT substring("Hello World",1,3) FROM Stream => "el"
Returns the length of a string.
SELECT length("Hello") FROM Stream => 5
Returns the string converted to uppercase.
SELECT upper("Hello World") FROM Stream => "HELLO WORLD"
Returns the string converted to lowercase.
SELECT lower("Hello World") FROM Stream => "hello world"