Facing issue with WHERE query

[BizBoy]

Hi,

I am trying a WHERE query for learning purpose.
I am facing an issue while writing this query.

When I copy where criteria from table, query gives result.
But when I manually type criteria, I get blank records.

Please see below queries I am using. I can not see any difference in both.
However, one query gives result and one does not.
The only change is 'London ' is copied from table in one query and in second query I have manually typed 'London '

Can anyone help me in this please.

SELECT * from Customers where City = 'London '
SELECT * from Customers where City = 'London '

Table copied from below link.

https://www.w3schools.com/sql/sql_distinct.asp

 

[Joe4]

I notice that you have a space after the word "London ".
If you are copying it from the internet, you may have a special space (like a non-breaking space), which is different from a regular space (data copied from the internet often uses these special spaces instead).

Personally, I do not like using spaces at the end of criteria values. I would probably do this instead:

SELECT * from Customers where LEFT(City,6)='London';

Then, it doesn't matter at all what comes after the word "London".

 

[xenou]

THis might have to do with the encoding of the the text values. Data copied from web pages can often have weird problems like this.

 

[BizBoy]

Hi Joe sir,
Thanks a lot for the help.

I try TRIM function in Excel VBA in such cases but was not aware that I can use LEFT in access to resolve this issue.
Have a nice day ahead.

 

[BizBoy]

Hi Xenou sir, thanks a lot for the help. Since I have copied this data for learning purpose.
I will trim this in excel before creating an access table for the same details.
This might be more safe. Have a nice day ahead.

 

[BizBoy]

Did bit data cleaning along with TRIM and CLEAN in excel to remove extra spaces.
Now it is working fine. Thanks.

 

[Joe4]

You are welcome!