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, SUBSTRING(CCHAR1,1) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1,5) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1,7) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1,8) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1,9) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1 FROM 5) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1 FROM 9) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1,5,2) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1,9,3) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR1 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR1	SUBSTRING(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, SUBSTRING(CCHAR2,1) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2,5) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2,7) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2,8) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2,9) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2 FROM 5) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2 FROM 9) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2,5,2) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2,9,3) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR2 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR2	SUBSTRING(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, SUBSTRING(CCHAR3,1) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3,5) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3,7) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3,8) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3,9) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3 FROM 5) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3 FROM 9) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3,5,2) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3,9,3) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR3 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR3	SUBSTRING(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, SUBSTRING(CCHAR4,1) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4,5) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4,7) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4,8) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4,9) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4 FROM 5) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4 FROM 9) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4,5,2) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4,9,3) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR4 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR4	SUBSTRING(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, SUBSTRING(CCHAR5,1) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5,5) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5,7) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5,8) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5,9) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5 FROM 5) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5 FROM 9) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5,5,2) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5,9,3) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR5 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR5	SUBSTRING(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, SUBSTRING(CCHAR6,1) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6,5) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6,7) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6,8) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6,9) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6 FROM 5) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6 FROM 9) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6,5,2) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6,9,3) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR6 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR6	SUBSTRING(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, SUBSTRING(CCHAR7,1) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7,5) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7,7) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7,8) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7,9) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7 FROM 5) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7 FROM 9) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7,5,2) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7,9,3) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR7 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR7	SUBSTRING(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, SUBSTRING(CCHAR8,1) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8,5) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8,7) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8,8) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8,9) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8 FROM 5) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8 FROM 9) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8,5,2) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8,9,3) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR8 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR8	SUBSTRING(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, SUBSTRING(CCHAR9,1) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9,5) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9,7) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9,8) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9,9) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9 FROM 5) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9 FROM 9) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9,5,2) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9,9,3) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR9 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR9	SUBSTRING(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, SUBSTRING(CCHAR255,1) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255,5) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255,7) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255,8) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255,9) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255 FROM 5) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255 FROM 9) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255,5,2) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255,9,3) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255 FROM 5 FOR 2) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CCHAR255 FROM 9 FOR 3) from datatypetestm;
cidx	CCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR1,1) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1,5) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1,7) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1,8) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1,9) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1 FROM 5) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1 FROM 9) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1,5,2) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1,9,3) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR1 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR1	SUBSTRING(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, SUBSTRING(CVCHAR2,1) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2,5) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2,7) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2,8) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2,9) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2 FROM 5) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2 FROM 9) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2,5,2) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2,9,3) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR2 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR2	SUBSTRING(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, SUBSTRING(CVCHAR3,1) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3,5) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3,7) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3,8) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3,9) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3 FROM 5) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3 FROM 9) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3,5,2) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3,9,3) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR3 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR3	SUBSTRING(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, SUBSTRING(CVCHAR4,1) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4,5) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4,7) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4,8) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4,9) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4 FROM 5) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4 FROM 9) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4,5,2) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4,9,3) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR4 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR4	SUBSTRING(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, SUBSTRING(CVCHAR5,1) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5,5) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5,7) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5,8) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5,9) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5 FROM 5) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5 FROM 9) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5,5,2) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5,9,3) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR5 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR5	SUBSTRING(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, SUBSTRING(CVCHAR6,1) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6,5) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6,7) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6,8) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6,9) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6 FROM 5) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6 FROM 9) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6,5,2) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6,9,3) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR6 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR6	SUBSTRING(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, SUBSTRING(CVCHAR7,1) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7,5) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7,7) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7,8) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7,9) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7 FROM 5) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7 FROM 9) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7,5,2) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7,9,3) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR7 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR7	SUBSTRING(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, SUBSTRING(CVCHAR8,1) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8,5) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8,7) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8,8) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8,9) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8 FROM 5) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8 FROM 9) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8,5,2) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8,9,3) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR8 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR8	SUBSTRING(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, SUBSTRING(CVCHAR255,1) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255,5) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255,7) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255,8) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255,9) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255 FROM 5) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255 FROM 9) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255,5,2) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255,9,3) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255 FROM 5 FOR 2) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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, SUBSTRING(CVCHAR255 FROM 9 FOR 3) from datatypetestm;
cidx	CVCHAR255	SUBSTRING(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 SUBSTRING(CCHAR1,1) <> CCHAR1;
cidx	CCHAR1
select cidx, CCHAR1 from datatypetestm where SUBSTRING(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 SUBSTRING(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
select cidx, CCHAR1 from datatypetestm where SUBSTRING(CCHAR1,8) <> 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 SUBSTRING(CCHAR1,9) <> 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 SUBSTRING(CCHAR1 FROM 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 SUBSTRING(CCHAR1 FROM 9) <> 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 SUBSTRING(CCHAR1,5,2) <> 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 SUBSTRING(CCHAR1,9,3) <> 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 SUBSTRING(CCHAR1 FROM 5 FOR 2) <> 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 SUBSTRING(CCHAR1 FROM 9 FOR 3) <> 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, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,1) <> CCHAR2;
cidx	CCHAR2
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,5) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,7) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,8) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,9) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2 FROM 5) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2 FROM 9) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,5,2) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2,9,3) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2 FROM 5 FOR 2) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR2 from datatypetestm where SUBSTRING(CCHAR2 FROM 9 FOR 3) <> CCHAR2;
cidx	CCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,1) <> CCHAR3;
cidx	CCHAR3
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,5) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,7) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,8) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,9) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3 FROM 5) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3 FROM 9) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,5,2) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3,9,3) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3 FROM 5 FOR 2) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR3 from datatypetestm where SUBSTRING(CCHAR3 FROM 9 FOR 3) <> CCHAR3;
cidx	CCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,1) <> CCHAR4;
cidx	CCHAR4
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,5) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,7) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,8) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,9) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4 FROM 5) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4 FROM 9) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,5,2) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4,9,3) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4 FROM 5 FOR 2) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR4 from datatypetestm where SUBSTRING(CCHAR4 FROM 9 FOR 3) <> CCHAR4;
cidx	CCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,1) <> CCHAR5;
cidx	CCHAR5
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,5) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,7) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,8) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,9) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5 FROM 5) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5 FROM 9) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,5,2) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5,9,3) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5 FROM 5 FOR 2) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR5 from datatypetestm where SUBSTRING(CCHAR5 FROM 9 FOR 3) <> CCHAR5;
cidx	CCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,1) <> CCHAR6;
cidx	CCHAR6
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,5) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,7) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,8) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,9) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6 FROM 5) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6 FROM 9) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,5,2) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6,9,3) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6 FROM 5 FOR 2) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR6 from datatypetestm where SUBSTRING(CCHAR6 FROM 9 FOR 3) <> CCHAR6;
cidx	CCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,1) <> CCHAR7;
cidx	CCHAR7
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,5) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,7) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,8) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,9) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7 FROM 5) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7 FROM 9) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,5,2) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7,9,3) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7 FROM 5 FOR 2) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR7 from datatypetestm where SUBSTRING(CCHAR7 FROM 9 FOR 3) <> CCHAR7;
cidx	CCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,1) <> CCHAR8;
cidx	CCHAR8
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,5) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,7) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,8) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,9) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8 FROM 5) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8 FROM 9) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,5,2) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8,9,3) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8 FROM 5 FOR 2) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR8 from datatypetestm where SUBSTRING(CCHAR8 FROM 9 FOR 3) <> CCHAR8;
cidx	CCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,1) <> CCHAR9;
cidx	CCHAR9
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,5) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,7) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,8) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,9) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9 FROM 5) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9 FROM 9) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,5,2) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9,9,3) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9 FROM 5 FOR 2) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR9 from datatypetestm where SUBSTRING(CCHAR9 FROM 9 FOR 3) <> CCHAR9;
cidx	CCHAR9
1	aaaaaaaaa
2	i
3	ii
4	iii
5	iiii
6	rrrrrrr
7	rrrrrrrr
8	rrrrrrrrr
9	rrrrrrrrr
10	zzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,1) <> CCHAR255;
cidx	CCHAR255
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,5) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,7) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,8) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,9) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255 FROM 5) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255 FROM 9) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,5,2) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255,9,3) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255 FROM 5 FOR 2) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CCHAR255 from datatypetestm where SUBSTRING(CCHAR255 FROM 9 FOR 3) <> CCHAR255;
cidx	CCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,1) <> CVCHAR1;
cidx	CVCHAR1
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,5) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,7) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,8) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,9) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1 FROM 5) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1 FROM 9) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,5,2) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1,9,3) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1 FROM 5 FOR 2) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR1 from datatypetestm where SUBSTRING(CVCHAR1 FROM 9 FOR 3) <> CVCHAR1;
cidx	CVCHAR1
1	a
2	a
3	a
4	a
5	a
6	z
7	z
8	z
9	z
10	z
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,1) <> CVCHAR2;
cidx	CVCHAR2
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,5) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,7) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,8) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,9) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2 FROM 5) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2 FROM 9) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,5,2) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2,9,3) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2 FROM 5 FOR 2) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR2 from datatypetestm where SUBSTRING(CVCHAR2 FROM 9 FOR 3) <> CVCHAR2;
cidx	CVCHAR2
1	aa
2	b
3	bb
4	bb
5	bb
6	yy
7	yy
8	yy
9	yy
10	zz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,1) <> CVCHAR3;
cidx	CVCHAR3
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,5) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,7) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,8) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,9) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3 FROM 5) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3 FROM 9) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,5,2) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3,9,3) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3 FROM 5 FOR 2) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR3 from datatypetestm where SUBSTRING(CVCHAR3 FROM 9 FOR 3) <> CVCHAR3;
cidx	CVCHAR3
1	aaa
2	c
3	cc
4	ccc
5	ccc
6	xxx
7	xxx
8	xxx
9	xxx
10	zzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,1) <> CVCHAR4;
cidx	CVCHAR4
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,5) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,7) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,8) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,9) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4 FROM 5) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4 FROM 9) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,5,2) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4,9,3) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4 FROM 5 FOR 2) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR4 from datatypetestm where SUBSTRING(CVCHAR4 FROM 9 FOR 3) <> CVCHAR4;
cidx	CVCHAR4
1	aaaa
2	d
3	dd
4	ddd
5	dddd
6	wwww
7	wwww
8	wwww
9	wwww
10	zzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,1) <> CVCHAR5;
cidx	CVCHAR5
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,5) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,7) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,8) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,9) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5 FROM 5) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5 FROM 9) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,5,2) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5,9,3) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5 FROM 5 FOR 2) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR5 from datatypetestm where SUBSTRING(CVCHAR5 FROM 9 FOR 3) <> CVCHAR5;
cidx	CVCHAR5
1	aaaaa
2	e
3	ee
4	eee
5	eeee
6	vvvvv
7	vvvvv
8	vvvvv
9	vvvvv
10	zzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,1) <> CVCHAR6;
cidx	CVCHAR6
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,5) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,7) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,8) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,9) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6 FROM 5) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6 FROM 9) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,5,2) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6,9,3) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6 FROM 5 FOR 2) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR6 from datatypetestm where SUBSTRING(CVCHAR6 FROM 9 FOR 3) <> CVCHAR6;
cidx	CVCHAR6
1	aaaaaa
2	f
3	ff
4	fff
5	ffff
6	uuuuuu
7	uuuuuu
8	uuuuuu
9	uuuuuu
10	zzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,1) <> CVCHAR7;
cidx	CVCHAR7
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,5) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,7) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,8) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,9) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7 FROM 5) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7 FROM 9) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,5,2) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7,9,3) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7 FROM 5 FOR 2) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR7 from datatypetestm where SUBSTRING(CVCHAR7 FROM 9 FOR 3) <> CVCHAR7;
cidx	CVCHAR7
1	aaaaaaa
2	g
3	gg
4	ggg
5	gggg
6	ttttttt
7	ttttttt
8	ttttttt
9	ttttttt
10	zzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,1) <> CVCHAR8;
cidx	CVCHAR8
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,5) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,7) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,8) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,9) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8 FROM 5) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8 FROM 9) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,5,2) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8,9,3) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8 FROM 5 FOR 2) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR8 from datatypetestm where SUBSTRING(CVCHAR8 FROM 9 FOR 3) <> CVCHAR8;
cidx	CVCHAR8
1	aaaaaaaa
2	h
3	hh
4	hhh
5	hhhh
6	sssssss
7	ssssssss
8	ssssssss
9	ssssssss
10	zzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,1) <> CVCHAR255;
cidx	CVCHAR255
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,5) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,7) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,8) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,9) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255 FROM 5) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255 FROM 9) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,5,2) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255,9,3) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255 FROM 5 FOR 2) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
select cidx, CVCHAR255 from datatypetestm where SUBSTRING(CVCHAR255 FROM 9 FOR 3) <> CVCHAR255;
cidx	CVCHAR255
1	aaaaaaaaaa
2	j
3	jj
4	jjj
5	jjjj
6	qqqqqqq
7	qqqqqqqq
8	qqqqqqqqq
9	qqqqqqqqqq
10	zzzzzzzzzz
DROP DATABASE regr_fe_substr;