오류데이타검증 - 숫자 이외의 데이타 확인하는 방법

테스트 테이블 생성 및 데이타 입력

DROP TABLE tbl;

CREATE TABLE tbl ( col1 int, col2 VARCHAR(100) );

INSERT INTO tbl (col1, col2 ) VALUES ( 1,'1');

INSERT INTO tbl (col1, col2 ) VALUES ( 2,'7');

INSERT INTO tbl (col1, col2 ) VALUES ( 3,'8');

INSERT INTO tbl (col1, col2 ) VALUES ( 4,'1,000');

INSERT INTO tbl (col1, col2 ) VALUES ( 5,'1,200,300');

INSERT INTO tbl (col1, col2 ) VALUES ( 6,' ');

INSERT INTO tbl (col1, col2 ) VALUES ( 7,'');

INSERT INTO tbl (col1, col2 ) VALUES ( 8,'0');

INSERT INTO tbl (col1, col2 ) VALUES ( 9,'!');

INSERT INTO tbl (col1, col2 ) VALUES (10,'^');

INSERT INTO tbl (col1, col2 ) VALUES (11,'&');

INSERT INTO tbl (col1, col2 ) VALUES (12,'ㄱ');

INSERT INTO tbl (col1, col2 ) VALUES (13,'x');

INSERT INTO tbl (col1, col2 ) VALUES (14,'x12');

INSERT INTO tbl (col1, col2 ) VALUES (15,'ㄱ123');

INSERT INTO tbl (col1, col2 ) VALUES (16,'123ㄱ098');

INSERT INTO tbl (col1, col2 ) VALUES (17,'123.0');