Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Mexico City, Mexico
    Posts
    2

    Exclamation Unanswered: SQL statement on a memo type field

    hello guys!

    i'm trying to write some sql code to select from a table, using a "memo" type field.

    as of today i have not been able to get it done, so i was wondering if any of you could answer a couple of questions:

    1) can i use a select statement with a where clause when the target column is of "memo" type?

    2) is this all right? "Select * From [Table Name] Where [Memo Field] Like '%[value to search for]%'"

    thanks in advance for the help! bye now...

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    1. No

    2. see 1.

    izy

  3. #3
    Join Date
    Sep 2003
    Location
    Mexico City, Mexico
    Posts
    2
    izy:

    is this only because this is MS Access? or does it apply to any db? i ask this because i could have the chance to handle this db using SQL Server...

    also, is there any other method i could use in order to retrieve the records i need from the table, perhaps not using the "like" statement?

    thanks again...

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    can't help you with other db (but i guess some do; some don't) but in access it is not possible to query within the memo field.

    there is a long way around: open a recordset and instr() the memo string... repeat for each memo. this will not be fast on a big db / long memos.

    can you survive with keywords? either manual kw or you could set up a library of kw and go thru the memo text on save.

    izy

  5. #5
    Join Date
    Sep 2003
    Location
    Dumfries, VA USA
    Posts
    8
    Firebird/Interbase will allow you to so.

Posting Permissions

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