var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL statement on a memo type field
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...
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?
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.
Firebird/Interbase will allow you to so.