SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Aug 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ms access query a memo field

    I have an access db with a memo field. I am trying to query this field to return a keyword and not get hits on derivatives.

    I am using a simple select statement with a like clause.
    select * from body
    where like "visit";

    But it will not return anything unless I use wildcards and then I get more then I want.

    Can someone but me on the right path?

    Thank you.

  2. #2
    SitePoint Enthusiast
    Join Date
    Aug 2011
    Location
    OH, USA
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the problem is space is a character
    when you use where fieldname like "visit"; it is does not make sense it is equal to where fieldname="visit";
    you cab use wildcards on any side of you value or on both sides depence of what you need


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •