文本

输出文本。

import alasql from 'alasql';

const result = alasql("SELECT 'Hello World' AS [文本]");
console.log(result);

[ { '文本': 'Hello World' } ]

文本长度。

import alasql from 'alasql';

const result = alasql("SELECT LEN('Hello World') AS r1, 'Hello Human'.length AS r2");
console.log(result);

[ { r1: 11, r2: 11 } ]

拼接文本。

import alasql from 'alasql';

const result = alasql("SELECT CONCAT('Hello', 'Human') AS r1, 'Hello' + 'World' AS r2");
console.log(result);

[ { r1: 'HelloWorld', r2: 'HelloHuman' } ]

截断文本。

import alasql from 'alasql';

const result = alasql("SELECT MID('Hello World', 7, 5) AS r1, 'Hello Human'.slice(6) AS r2");
console.log(result);

[ { r1: 'World', r2: 'Human' } ]

文本 ​