Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Select records based on contents of memo field
Is it possible to create a SELECT-SQL statement that will return records based on the content of a memo field?
For example, I have a table as follows:
projectid C(15)
varEng M
varContr M
etc..
The varEng and VarContr memo fields contain a number of company ids or may possibly be empty. I would like to be able to select only those projectids that contain a particular company id in atleast one of the memo fields. I hope this makes sense. Any suggestions would be greatly appreciated.
Thanks in advance,
Russell
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement