1
2
3
4
5
6
7
8
9
10
11
|
/* syntax version 1 */
SELECT
value,
String::ReplaceAll(value, "as", "zzz") AS all,
String::ReplaceFirst(value, "a", "z") AS first,
String::ReplaceLast(value, "a", "z") AS last,
String::ReplaceFirst(value, "a", "zz") AS first2,
String::ReplaceLast(value, "a", "zz") AS last2,
String::ReplaceFirst(value, "a", "") AS first3,
String::ReplaceLast(value, "a", "") AS last3
FROM Input;
|
