That sadly didn't work. I now know what the problem is but don't know
how to fix it. See that I am trying to do is filter out records that
have the word plonk anywhere in the notes. In access it is easy. I just use:
Where Notes not like "*plonk*"
works great...The problem in deplhi seems to be the *. If you use:
Where Notes not like "plonk" it will only filter that record out if
the only word in the notes is plonk which is why the *'s are required.
>hi try this i think its will work
>
>Query1.Close;
>Query1.SQL.Clear;
>Query1.SQL.Add('select *');
>Query1.SQL.Add('from Stuff');
>Query1.SQL.Add('where Notes not like "plonk"');
>Query1.Open;
>
>if it can help let me know.
>
>Un Gran Saludo
>---------------------------------------------
><http://www.khaarsen.ueuo.com>http://www.khaarsen.ueuo.com
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
><http://mail.yahoo.com>http://mail.yahoo.com
>
[Non-text portions of this message have been removed]
-------------------------------------------------------
Home: http://groups.yahoo.com/group/delphi-programming/
Remove: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-programming/
<*> 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/
