Uri,

I have been looking at that all morning and trying to understand it fully.

using the following query

SELECT MyDate, ISDATE(CommissionDate) AS Expr1 FROM MyTable

this returns a 1 or 0

the problem with ISDATE() is that it seems to rely on an american date
format

so 13/02/2003 is invalid whereas 02/13/2003 is valid

being in the UK the function appears to be as much use as a chocolate fire
guard

Thanks

Mike




"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OTLvllykIHA.5660@TK2MSFTNGP02.phx.gbl...
> 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
>>
>
>