hi The Below sql statement works out. thanks for all. regards Viswanathan R
--- Chad <[EMAIL PROTECTED]> wrote: > > PartNo Description > > 111 Hello > > 123 Hello > > 456 World > > 123 Hello > > 123 Hello > > 123 Hello > > 123 Hello > > > I want to delete the first occurrence of "123 > Hello" to leave > > You may want to use the TOP clause. I have not > tested this in Access, but I > know it works in SQL. > > DELETE yourtable > FROM (SELECT TOP 1 * FROM yourtable) AS x1 > WHERE yourtable.partno = x1.partno > AND x1.partno = 123 > AND x1.description LIKE 'Hello' > > More info here: > http://msdn.microsoft.com/library/en-us/tsqlref/ts_de-dz_9lut.asp > > -Chad > > ===== Thanks & Regards Viswanathan R __________________________________ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
