Search question

[Gregory Kowalski]

Hello,

When  I make a search with the following expression:

  whichSearch = "select * from Table where catalognumber = "&keyword&" 
order by catalog"

The catalog numbers are in a string field.


0014-01 gives me a result but 0014-01X does not. Neither does A0759-05. 
  It seems that whenever I the catalog number contains a letter it 
cannot be found.


What is the reason for this?

Thanks for your help

Greg