selection of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i'm trying to select certain records from my file. For example, how can I
select all records that end in '-5' or that contain a particular word

Thanks
 
Select * From MyTable Where MyField Like "*-5"
or
Select * From MyTable Where MyField Like "*AnyPartOfField*"
 
Michel

A query can use a field that you add, based on a function like Right(). Add
a field in your query something like:
Right([YourField],2)
then set the criterion for that field as "-5".

If you want a query criterion to look for a field that contains the word
"word", use something like the following for the criterion:

Like * & word & *

And if you want to parameterize it, make it:

Like * & [Enter your search string/word] & *
 
Back
Top