I'm assuming that you haven't really named your table as 'table' BTW: You don't need the parentheses around the where clause, only around the list. Taz
> UPDATE Table > SET Field = 1 > WHERE (ID in (12,13,14)) > > if there is what would be the correct syntax to get the desired result.. > > Thanks > > @J > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
