i want to make a udf in sql which checks whether the varchar data contains data suitable for date,if yes then return 1 else return 0.

isdate(varchar(10)) --

in my database i want data to be stored in yyyy/mm/dd format,
this data is to be checked whether this contains right data after substringing in date format of BD2.

awaiting urs reply,

thanks and Regards