create table table1
(
data_value varchar (50),
sql_data_type varchar (50)
)
insert into table1(data_value,sql_data_type)
values ('11/02/2013', 'DATE')
insert into table1(data_value,sql_data_type)
values ('', 'DATE')
insert into table1(data_value,sql_data_type)
values (11.3, 'decimal')
insert into table1(data_value,sql_data_type)
values ('not assigned', 'DATE')
insert into table1(data_value,sql_data_type)
values (null, 'varchar')
insert into table1(data_value,sql_data_type)
values ($, 'varchar')
From these information i need to check wether data_value follow the sql_data_type shown data type.If not they should be moved to another table.