Afficher un message
Vieux 31/03/2008, 13h08   #1
Mike Fellows
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Query a Table to return Non-Date values

Hi

I have a table with dates stored in a nvarchar(75), I would like to move
this over to datetime (for obvious reasons)

the problem is the field has some 'bad data'

how can i query the nvarchar field to return me anything that isnt a date?
so i can fix and convert

Thanks in advance

Mike


  Réponse avec citation
 
Page generated in 3,40011 seconds with 9 queries