dbTalk Databases Forums  

exact queries of memos

comp.databases.xbase.codebase comp.databases.xbase.codebase


Discuss exact queries of memos in the comp.databases.xbase.codebase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Greg S
 
Posts: n/a

Default exact queries of memos - 09-12-2003 , 01:08 PM






I've searched the knowledgebase and the newsgroup for a possible
solution to this, but to no avail…

I want to create a query against a memo column for a specific value.

E.g. FIELDNAME = "ABC"

With a string field, I pad the expression to the field size, but this
approach does not work with memos since there is no fixed field size.

So, just leaving the expression as is, I get back "ABC" along with
everything else that starts with "ABC". How can I write a query that
would give me back just records where FIELDNAME = "ABC"? To me, what's
really missing is a LEN() expression for memo fields, so I could go

(FIELDNAME = "ABC") .AND. (LEN(FIELDNAME) = 3)

Thx!

Greg

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.