I cannot use parse..

Using Sql 2008..

Thanks though it was really great info...

thank you guys...

i finally did it..

I used isdate to validate date datatypes

and isnumeric for others

i used the same syntax as that of the parse statement.....

Thank you

once again

THANKS GUYS ...I GOT IT

shravan.gavva (11/20/2013)

---

I tried to use try-catch

it says i have a syntax error...doesnt matter how many times I checked..

I have hardly 129 rows. I checked it has in the format...

I tried to use try-catch

it says i have a syntax error...doesnt matter how many times I checked..

I have hardly 129 datatypes. I checked it has in the format of...

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...

I could not change the datatype of data_value