Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prasad332
Starting Member
3 Posts |
 Posted - 2007-11-20 : 14:02:38
|
| Hi Friends,I need a select query to identify how many records violate the basic dateformat, later on i update the junkdata with null.Initially I have a database, in which one field(for Date) is given as Varchar, now as we know varchar accepts all types of data, when migrating the same data to another server, i am using Date as datatype for the new field and want to remove all other format's of data (Junk data) entered to that field and want to ratain only the general format i.e, MM/DD/YYYY or MM/DD/YYYY, this query should also support MM<=12, DD<=31 Regards,Prasad K |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Select Query and Update