DROP DATABASE IF EXISTS regr_fe_substr;
CREATE DATABASE regr_fe_substr;
USE regr_fe_substr;
Warnings:
Note	1051	Unknown table 'regr_fe_substr.datatypetestm'
select cidx, CCHAR1, SUBSTR(CCHAR1,1) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,1)
1	a	a
2	a	a
3	a	a
4	a	a
5	a	a
6	z	z
7	z	z
8	z	z
9	z	z
10	z	z
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1,5) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,5)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1,7) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,7)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1,8) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,8)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1,9) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,9)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 5) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1 FROM 5)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 9) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1 FROM 9)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1,5,2) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,5,2)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1,9,3) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1,9,3)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1 FROM 5 FOR 2)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR1	SUBSTR(CCHAR1 FROM 9 FOR 3)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,1) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,1)
1	aa	aa
2	b	b
3	bb	bb
4	bb	bb
5	bb	bb
6	yy	yy
7	yy	yy
8	yy	yy
9	yy	yy
10	zz	zz
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,5) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,5)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,7) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,7)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,8) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,8)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,9) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,9)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 5) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2 FROM 5)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 9) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2 FROM 9)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,5,2) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,5,2)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2,9,3) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2,9,3)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2 FROM 5 FOR 2)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR2	SUBSTR(CCHAR2 FROM 9 FOR 3)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,1) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,1)
1	aaa	aaa
2	c	c
3	cc	cc
4	ccc	ccc
5	ccc	ccc
6	xxx	xxx
7	xxx	xxx
8	xxx	xxx
9	xxx	xxx
10	zzz	zzz
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,5) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,5)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,7) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,7)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,8) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,8)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,9) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,9)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 5) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3 FROM 5)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 9) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3 FROM 9)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,5,2) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,5,2)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3,9,3) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3,9,3)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3 FROM 5 FOR 2)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR3	SUBSTR(CCHAR3 FROM 9 FOR 3)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,1) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,1)
1	aaaa	aaaa
2	d	d
3	dd	dd
4	ddd	ddd
5	dddd	dddd
6	wwww	wwww
7	wwww	wwww
8	wwww	wwww
9	wwww	wwww
10	zzzz	zzzz
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,5) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,5)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,7) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,7)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,8) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,8)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,9) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,9)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 5) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4 FROM 5)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 9) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4 FROM 9)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,5,2) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,5,2)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4,9,3) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4,9,3)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4 FROM 5 FOR 2)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR4	SUBSTR(CCHAR4 FROM 9 FOR 3)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,1) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,1)
1	aaaaa	aaaaa
2	e	e
3	ee	ee
4	eee	eee
5	eeee	eeee
6	vvvvv	vvvvv
7	vvvvv	vvvvv
8	vvvvv	vvvvv
9	vvvvv	vvvvv
10	zzzzz	zzzzz
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,5) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,5)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,7) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,7)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,8) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,8)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,9) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,9)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 5) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5 FROM 5)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 9) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5 FROM 9)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,5,2) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,5,2)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5,9,3) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5,9,3)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5 FROM 5 FOR 2)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR5	SUBSTR(CCHAR5 FROM 9 FOR 3)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,1) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,1)
1	aaaaaa	aaaaaa
2	f	f
3	ff	ff
4	fff	fff
5	ffff	ffff
6	uuuuuu	uuuuuu
7	uuuuuu	uuuuuu
8	uuuuuu	uuuuuu
9	uuuuuu	uuuuuu
10	zzzzzz	zzzzzz
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,5) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,5)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,7) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,7)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,8) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,8)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,9) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,9)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 5) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6 FROM 5)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 9) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6 FROM 9)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,5,2) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,5,2)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6,9,3) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6,9,3)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6 FROM 5 FOR 2)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR6	SUBSTR(CCHAR6 FROM 9 FOR 3)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,1) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,1)
1	aaaaaaa	aaaaaaa
2	g	g
3	gg	gg
4	ggg	ggg
5	gggg	gggg
6	ttttttt	ttttttt
7	ttttttt	ttttttt
8	ttttttt	ttttttt
9	ttttttt	ttttttt
10	zzzzzzz	zzzzzzz
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,5) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,5)
1	aaaaaaa	aaa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	ttt
7	ttttttt	ttt
8	ttttttt	ttt
9	ttttttt	ttt
10	zzzzzzz	zzz
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,7) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,7)
1	aaaaaaa	a
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	t
7	ttttttt	t
8	ttttttt	t
9	ttttttt	t
10	zzzzzzz	z
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,8) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,8)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,9) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,9)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 5) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7 FROM 5)
1	aaaaaaa	aaa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	ttt
7	ttttttt	ttt
8	ttttttt	ttt
9	ttttttt	ttt
10	zzzzzzz	zzz
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 9) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7 FROM 9)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,5,2) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,5,2)
1	aaaaaaa	aa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	tt
7	ttttttt	tt
8	ttttttt	tt
9	ttttttt	tt
10	zzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7,9,3) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7,9,3)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7 FROM 5 FOR 2)
1	aaaaaaa	aa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	tt
7	ttttttt	tt
8	ttttttt	tt
9	ttttttt	tt
10	zzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR7	SUBSTR(CCHAR7 FROM 9 FOR 3)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,1) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,1)
1	aaaaaaaa	aaaaaaaa
2	h	h
3	hh	hh
4	hhh	hhh
5	hhhh	hhhh
6	sssssss	sssssss
7	ssssssss	ssssssss
8	ssssssss	ssssssss
9	ssssssss	ssssssss
10	zzzzzzzz	zzzzzzzz
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,5) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,5)
1	aaaaaaaa	aaaa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	sss
7	ssssssss	ssss
8	ssssssss	ssss
9	ssssssss	ssss
10	zzzzzzzz	zzzz
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,7) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,7)
1	aaaaaaaa	aa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	s
7	ssssssss	ss
8	ssssssss	ss
9	ssssssss	ss
10	zzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,8) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,8)
1	aaaaaaaa	a
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	s
8	ssssssss	s
9	ssssssss	s
10	zzzzzzzz	z
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,9) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,9)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 5) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8 FROM 5)
1	aaaaaaaa	aaaa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	sss
7	ssssssss	ssss
8	ssssssss	ssss
9	ssssssss	ssss
10	zzzzzzzz	zzzz
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 9) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8 FROM 9)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,5,2) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,5,2)
1	aaaaaaaa	aa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	ss
7	ssssssss	ss
8	ssssssss	ss
9	ssssssss	ss
10	zzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8,9,3) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8,9,3)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8 FROM 5 FOR 2)
1	aaaaaaaa	aa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	ss
7	ssssssss	ss
8	ssssssss	ss
9	ssssssss	ss
10	zzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR8	SUBSTR(CCHAR8 FROM 9 FOR 3)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,1) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,1)
1	aaaaaaaaa	aaaaaaaaa
2	i	i
3	ii	ii
4	iii	iii
5	iiii	iiii
6	rrrrrrr	rrrrrrr
7	rrrrrrrr	rrrrrrrr
8	rrrrrrrrr	rrrrrrrrr
9	rrrrrrrrr	rrrrrrrrr
10	zzzzzzzzz	zzzzzzzzz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,5) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,5)
1	aaaaaaaaa	aaaaa
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	rrr
7	rrrrrrrr	rrrr
8	rrrrrrrrr	rrrrr
9	rrrrrrrrr	rrrrr
10	zzzzzzzzz	zzzzz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,7) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,7)
1	aaaaaaaaa	aaa
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	r
7	rrrrrrrr	rr
8	rrrrrrrrr	rrr
9	rrrrrrrrr	rrr
10	zzzzzzzzz	zzz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,8) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,8)
1	aaaaaaaaa	aa
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	
7	rrrrrrrr	r
8	rrrrrrrrr	rr
9	rrrrrrrrr	rr
10	zzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,9) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,9)
1	aaaaaaaaa	a
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	
7	rrrrrrrr	
8	rrrrrrrrr	r
9	rrrrrrrrr	r
10	zzzzzzzzz	z
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 5) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9 FROM 5)
1	aaaaaaaaa	aaaaa
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	rrr
7	rrrrrrrr	rrrr
8	rrrrrrrrr	rrrrr
9	rrrrrrrrr	rrrrr
10	zzzzzzzzz	zzzzz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 9) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9 FROM 9)
1	aaaaaaaaa	a
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	
7	rrrrrrrr	
8	rrrrrrrrr	r
9	rrrrrrrrr	r
10	zzzzzzzzz	z
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,5,2) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,5,2)
1	aaaaaaaaa	aa
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	rr
7	rrrrrrrr	rr
8	rrrrrrrrr	rr
9	rrrrrrrrr	rr
10	zzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9,9,3) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9,9,3)
1	aaaaaaaaa	a
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	
7	rrrrrrrr	
8	rrrrrrrrr	r
9	rrrrrrrrr	r
10	zzzzzzzzz	z
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9 FROM 5 FOR 2)
1	aaaaaaaaa	aa
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	rr
7	rrrrrrrr	rr
8	rrrrrrrrr	rr
9	rrrrrrrrr	rr
10	zzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR9	SUBSTR(CCHAR9 FROM 9 FOR 3)
1	aaaaaaaaa	a
2	i	
3	ii	
4	iii	
5	iiii	
6	rrrrrrr	
7	rrrrrrrr	
8	rrrrrrrrr	r
9	rrrrrrrrr	r
10	zzzzzzzzz	z
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,1) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,1)
1	aaaaaaaaaa	aaaaaaaaaa
2	j	j
3	jj	jj
4	jjj	jjj
5	jjjj	jjjj
6	qqqqqqq	qqqqqqq
7	qqqqqqqq	qqqqqqqq
8	qqqqqqqqq	qqqqqqqqq
9	qqqqqqqqqq	qqqqqqqqqq
10	zzzzzzzzzz	zzzzzzzzzz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,5) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,5)
1	aaaaaaaaaa	aaaaaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qqq
7	qqqqqqqq	qqqq
8	qqqqqqqqq	qqqqq
9	qqqqqqqqqq	qqqqqq
10	zzzzzzzzzz	zzzzzz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,7) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,7)
1	aaaaaaaaaa	aaaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	q
7	qqqqqqqq	qq
8	qqqqqqqqq	qqq
9	qqqqqqqqqq	qqqq
10	zzzzzzzzzz	zzzz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,8) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,8)
1	aaaaaaaaaa	aaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	q
8	qqqqqqqqq	qq
9	qqqqqqqqqq	qqq
10	zzzzzzzzzz	zzz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,9) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,9)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 5) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255 FROM 5)
1	aaaaaaaaaa	aaaaaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qqq
7	qqqqqqqq	qqqq
8	qqqqqqqqq	qqqqq
9	qqqqqqqqqq	qqqqqq
10	zzzzzzzzzz	zzzzzz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 9) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255 FROM 9)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,5,2) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,5,2)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qq
7	qqqqqqqq	qq
8	qqqqqqqqq	qq
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255,9,3) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255,9,3)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255 FROM 5 FOR 2)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qq
7	qqqqqqqq	qq
8	qqqqqqqqq	qq
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR255	SUBSTR(CCHAR255 FROM 9 FOR 3)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,1) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,1)
1	a	a
2	a	a
3	a	a
4	a	a
5	a	a
6	z	z
7	z	z
8	z	z
9	z	z
10	z	z
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,5) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,5)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,7) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,7)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,8) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,8)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,9) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,9)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 5) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1 FROM 5)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 9) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1 FROM 9)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,5,2) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,5,2)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1,9,3) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1,9,3)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1 FROM 5 FOR 2)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR1	SUBSTR(CVCHAR1 FROM 9 FOR 3)
1	a	
2	a	
3	a	
4	a	
5	a	
6	z	
7	z	
8	z	
9	z	
10	z	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,1) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,1)
1	aa	aa
2	b	b
3	bb	bb
4	bb	bb
5	bb	bb
6	yy	yy
7	yy	yy
8	yy	yy
9	yy	yy
10	zz	zz
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,5) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,5)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,7) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,7)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,8) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,8)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,9) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,9)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 5) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2 FROM 5)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 9) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2 FROM 9)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,5,2) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,5,2)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2,9,3) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2,9,3)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2 FROM 5 FOR 2)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR2	SUBSTR(CVCHAR2 FROM 9 FOR 3)
1	aa	
2	b	
3	bb	
4	bb	
5	bb	
6	yy	
7	yy	
8	yy	
9	yy	
10	zz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,1) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,1)
1	aaa	aaa
2	c	c
3	cc	cc
4	ccc	ccc
5	ccc	ccc
6	xxx	xxx
7	xxx	xxx
8	xxx	xxx
9	xxx	xxx
10	zzz	zzz
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,5) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,5)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,7) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,7)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,8) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,8)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,9) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,9)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 5) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3 FROM 5)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 9) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3 FROM 9)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,5,2) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,5,2)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3,9,3) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3,9,3)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3 FROM 5 FOR 2)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR3	SUBSTR(CVCHAR3 FROM 9 FOR 3)
1	aaa	
2	c	
3	cc	
4	ccc	
5	ccc	
6	xxx	
7	xxx	
8	xxx	
9	xxx	
10	zzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,1) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,1)
1	aaaa	aaaa
2	d	d
3	dd	dd
4	ddd	ddd
5	dddd	dddd
6	wwww	wwww
7	wwww	wwww
8	wwww	wwww
9	wwww	wwww
10	zzzz	zzzz
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,5) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,5)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,7) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,7)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,8) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,8)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,9) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,9)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 5) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4 FROM 5)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 9) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4 FROM 9)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,5,2) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,5,2)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4,9,3) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4,9,3)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4 FROM 5 FOR 2)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR4	SUBSTR(CVCHAR4 FROM 9 FOR 3)
1	aaaa	
2	d	
3	dd	
4	ddd	
5	dddd	
6	wwww	
7	wwww	
8	wwww	
9	wwww	
10	zzzz	
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,1) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,1)
1	aaaaa	aaaaa
2	e	e
3	ee	ee
4	eee	eee
5	eeee	eeee
6	vvvvv	vvvvv
7	vvvvv	vvvvv
8	vvvvv	vvvvv
9	vvvvv	vvvvv
10	zzzzz	zzzzz
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,5) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,5)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,7) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,7)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,8) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,8)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,9) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,9)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 5) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5 FROM 5)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 9) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5 FROM 9)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,5,2) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,5,2)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5,9,3) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5,9,3)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5 FROM 5 FOR 2)
1	aaaaa	a
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	v
7	vvvvv	v
8	vvvvv	v
9	vvvvv	v
10	zzzzz	z
11	NULL	NULL
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR5	SUBSTR(CVCHAR5 FROM 9 FOR 3)
1	aaaaa	
2	e	
3	ee	
4	eee	
5	eeee	
6	vvvvv	
7	vvvvv	
8	vvvvv	
9	vvvvv	
10	zzzzz	
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,1) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,1)
1	aaaaaa	aaaaaa
2	f	f
3	ff	ff
4	fff	fff
5	ffff	ffff
6	uuuuuu	uuuuuu
7	uuuuuu	uuuuuu
8	uuuuuu	uuuuuu
9	uuuuuu	uuuuuu
10	zzzzzz	zzzzzz
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,5) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,5)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,7) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,7)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,8) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,8)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,9) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,9)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 5) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6 FROM 5)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 9) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6 FROM 9)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,5,2) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,5,2)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6,9,3) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6,9,3)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6 FROM 5 FOR 2)
1	aaaaaa	aa
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	uu
7	uuuuuu	uu
8	uuuuuu	uu
9	uuuuuu	uu
10	zzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR6	SUBSTR(CVCHAR6 FROM 9 FOR 3)
1	aaaaaa	
2	f	
3	ff	
4	fff	
5	ffff	
6	uuuuuu	
7	uuuuuu	
8	uuuuuu	
9	uuuuuu	
10	zzzzzz	
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,1) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,1)
1	aaaaaaa	aaaaaaa
2	g	g
3	gg	gg
4	ggg	ggg
5	gggg	gggg
6	ttttttt	ttttttt
7	ttttttt	ttttttt
8	ttttttt	ttttttt
9	ttttttt	ttttttt
10	zzzzzzz	zzzzzzz
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,5) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,5)
1	aaaaaaa	aaa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	ttt
7	ttttttt	ttt
8	ttttttt	ttt
9	ttttttt	ttt
10	zzzzzzz	zzz
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,7) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,7)
1	aaaaaaa	a
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	t
7	ttttttt	t
8	ttttttt	t
9	ttttttt	t
10	zzzzzzz	z
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,8) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,8)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,9) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,9)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 5) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7 FROM 5)
1	aaaaaaa	aaa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	ttt
7	ttttttt	ttt
8	ttttttt	ttt
9	ttttttt	ttt
10	zzzzzzz	zzz
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 9) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7 FROM 9)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,5,2) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,5,2)
1	aaaaaaa	aa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	tt
7	ttttttt	tt
8	ttttttt	tt
9	ttttttt	tt
10	zzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7,9,3) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7,9,3)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7 FROM 5 FOR 2)
1	aaaaaaa	aa
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	tt
7	ttttttt	tt
8	ttttttt	tt
9	ttttttt	tt
10	zzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR7	SUBSTR(CVCHAR7 FROM 9 FOR 3)
1	aaaaaaa	
2	g	
3	gg	
4	ggg	
5	gggg	
6	ttttttt	
7	ttttttt	
8	ttttttt	
9	ttttttt	
10	zzzzzzz	
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,1) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,1)
1	aaaaaaaa	aaaaaaaa
2	h	h
3	hh	hh
4	hhh	hhh
5	hhhh	hhhh
6	sssssss	sssssss
7	ssssssss	ssssssss
8	ssssssss	ssssssss
9	ssssssss	ssssssss
10	zzzzzzzz	zzzzzzzz
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,5) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,5)
1	aaaaaaaa	aaaa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	sss
7	ssssssss	ssss
8	ssssssss	ssss
9	ssssssss	ssss
10	zzzzzzzz	zzzz
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,7) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,7)
1	aaaaaaaa	aa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	s
7	ssssssss	ss
8	ssssssss	ss
9	ssssssss	ss
10	zzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,8) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,8)
1	aaaaaaaa	a
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	s
8	ssssssss	s
9	ssssssss	s
10	zzzzzzzz	z
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,9) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,9)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 5) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8 FROM 5)
1	aaaaaaaa	aaaa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	sss
7	ssssssss	ssss
8	ssssssss	ssss
9	ssssssss	ssss
10	zzzzzzzz	zzzz
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 9) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8 FROM 9)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,5,2) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,5,2)
1	aaaaaaaa	aa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	ss
7	ssssssss	ss
8	ssssssss	ss
9	ssssssss	ss
10	zzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8,9,3) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8,9,3)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8 FROM 5 FOR 2)
1	aaaaaaaa	aa
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	ss
7	ssssssss	ss
8	ssssssss	ss
9	ssssssss	ss
10	zzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR8	SUBSTR(CVCHAR8 FROM 9 FOR 3)
1	aaaaaaaa	
2	h	
3	hh	
4	hhh	
5	hhhh	
6	sssssss	
7	ssssssss	
8	ssssssss	
9	ssssssss	
10	zzzzzzzz	
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,1) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,1)
1	aaaaaaaaaa	aaaaaaaaaa
2	j	j
3	jj	jj
4	jjj	jjj
5	jjjj	jjjj
6	qqqqqqq	qqqqqqq
7	qqqqqqqq	qqqqqqqq
8	qqqqqqqqq	qqqqqqqqq
9	qqqqqqqqqq	qqqqqqqqqq
10	zzzzzzzzzz	zzzzzzzzzz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,5) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,5)
1	aaaaaaaaaa	aaaaaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qqq
7	qqqqqqqq	qqqq
8	qqqqqqqqq	qqqqq
9	qqqqqqqqqq	qqqqqq
10	zzzzzzzzzz	zzzzzz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,7) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,7)
1	aaaaaaaaaa	aaaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	q
7	qqqqqqqq	qq
8	qqqqqqqqq	qqq
9	qqqqqqqqqq	qqqq
10	zzzzzzzzzz	zzzz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,8) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,8)
1	aaaaaaaaaa	aaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	q
8	qqqqqqqqq	qq
9	qqqqqqqqqq	qqq
10	zzzzzzzzzz	zzz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,9) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,9)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 5) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255 FROM 5)
1	aaaaaaaaaa	aaaaaa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qqq
7	qqqqqqqq	qqqq
8	qqqqqqqqq	qqqqq
9	qqqqqqqqqq	qqqqqq
10	zzzzzzzzzz	zzzzzz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 9) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255 FROM 9)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,5,2) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,5,2)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qq
7	qqqqqqqq	qq
8	qqqqqqqqq	qq
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255,9,3) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255,9,3)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255 FROM 5 FOR 2)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	qq
7	qqqqqqqq	qq
8	qqqqqqqqq	qq
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR255	SUBSTR(CVCHAR255 FROM 9 FOR 3)
1	aaaaaaaaaa	aa
2	j	
3	jj	
4	jjj	
5	jjjj	
6	qqqqqqq	
7	qqqqqqqq	
8	qqqqqqqqq	q
9	qqqqqqqqqq	qq
10	zzzzzzzzzz	zz
11	NULL	NULL
select cidx, CCHAR1 from datatypetestm where SUBSTR(CCHAR1,1) <> CCHAR1;
cidx	CCHAR1
select cidx, CCHAR1 from datatypetestm where SUBSTR(CCHAR1,5) <> CCHAR1;
cidx	CCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CCHAR1 from datatypetestm where SUBSTR(CCHAR1,7) <> CCHAR1;
cidx	CCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
DROP DATABASE regr_fe_substr;