Thanks Sean.

Apologies for using the wrong format, I wasn't sure which ifcode to use, but will remember for future reference

Phil Parkin (4/6/2012)

Hmm, clearly not, as you have duplicates 🙂

I'm therefore guessing that this table does not have...

the key field is a concatenate of LocalID + DSeen + POD

thanks - but how do i display both duplicate records in the same query?

thanks, i have created a view with the extra columns to display in the way required

hi,

how would i get the field values to automatically show the display format rather than the sql standard format?

yes, the destination is set to datetime.

But the cast outputs in the following format '2011-08-09 00:00:00.000'

ideally i would like the dates without the seperators

based on your code i tried the following:

update [table1]

set [ddate2] = convert(datetime,CAST([ddate] as datetime),112)

but it now outputs '2011-09-01 00:00:00'

its fine, i've added this to the where clause:

and XBD >'0'