Udah dicoba tapi blom bisa2 nih.
Contoh nya gini . Data : 1234a, 3b, 1234567c saya hanya mau ambil data yang 1234567c aja.. pake NOT LIKE '%a' or NOT LIKE '%b' masih muncul 3 3 nya.. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of malx 97 Sent: Wednesday, February 06, 2008 3:03 PM To: [email protected] Subject: Re: [indopb] tanya dong Coba Where [filedname] not like '%a%' and [filedname] not like '%b%' -------Original Message------- From: Rio Albert <mailto:[EMAIL PROTECTED]> Date: 05/02/2008 22:54:25 To: [EMAIL PROTECTED] <mailto:[email protected]> com Subject: [indopb] tanya dong PB'rs.. Kalo pemakaian where clause EXISTSatau NOT EXISTS gmn ya ? Contoh kasus : saya mau query data yang mana where caulse nya tdk terdapat huruf 'a' dan huruf 'b' Mohon pencerahannya ..TQ Rio Albert _____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try <http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62sR8H DtDypao8Wcj9tAcJ%20> it now.
