Problem while retrieving bad data

• kudla

  SSC Enthusiast

  Points: 166

  More actions

  May 13, 2004 at 9:49 am

  #82890

  Hi

  I have a table say Orders with a column Orderdate. I have to base my query on OrderDate. The problem is that Orderdate is a char column and contains junk characters.

  Hence my query

  select * from Orders  where convert(datetime,Orderdate)>getdate() fails miserably.

  The rows which contain junk characters for Orderdate need to be excluded.

  any pointers would be greatly appreciated.

  Rgds

  Shyam

   

   

• Michael Bianchi

  SSC Journeyman

  Points: 90

  More actions

  May 13, 2004 at 12:04 pm

  #506364

  Try the following:

  select * from Orders 

  where convert(datetime, isdate(Orderdate)) < getdate() and isdate(Orderdate) = 1

  Michael.

• kudla

  SSC Enthusiast

  Points: 166

  More actions

  May 14, 2004 at 3:38 am

  #506443

  Thanx very much

  It worked

  U dont know how grateful I am