- Joined
- Jun 9, 2006
- Messages
- 1
- Reaction score
- 0
I am trying to import data from access to excel by data-import data- new database query.
my data base has a field named contract and the some of the values are h100, h1234, H100, H1234.
I only need to import values H100 and H1234 and not import h100 and h1234. when i do a query ( select * where contract in ('H100','H1234)) it return me both upercase and lower case h values
How can i filter this in the query to get the right data?
my data base has a field named contract and the some of the values are h100, h1234, H100, H1234.
I only need to import values H100 and H1234 and not import h100 and h1234. when i do a query ( select * where contract in ('H100','H1234)) it return me both upercase and lower case h values
How can i filter this in the query to get the right data?