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.