Good morning to all, I need help for this problem: I take regularly some data from a database that is case sensitive. Since some time original data start to be different just for capital letter and I would like to avoid to change too much my Access database with which I extract the data. I have the following problem that can be summarised in this (in this description I simplified using only two table): I downloaded in Access the data I have 2 tables in Access where this data is saved. aptbstr01 aptbstr02 in each table I have 2 record Aaa AAA When I make a query with the query generator of access as follow to see the record that have the same filed in both table: SELECT aptbstr01.code, aptbstr02.code FROM aptbstr01 INNER JOIN aptbstr02 ON aptbstr01.code = aptbstr02.code; I get a result of 4 record because for Access is not case sensitive and mainly is considering double the record that has one field that differ only for the capital letter respect another record. I know that I can use ASC function to transform the value in the asci character and after I can join the asci field but I would like to simplify since join query between the fields that have this issue are more than one and sometime involving a lot of table connected. I would like to force access when it is doing the join to compare the asci character of my value so to consider Aaa different from AAA Is this possible? Any suggestion how to manage this issue? Thank you Valentino
Posted by: valentino.avvisati@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar