Mike
Take a look at ISDATE () function



"Mike Fellows" <mike.fellows@equityhouse.NO.SPAM.co.uk> wrote in message
news:KeadnZwJPKHNSW3anZ2dneKdnZydnZ2d@giganews.com ...
> 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
>