I have a simple SOQL query on Account which has a field Full\_Address\_\_c which is joint of Billing Street, City Zip.

When I use this field as a filter it doesn't return the records:

Example:

```
String accountAddress = [SELECT Full_Address__c FROM Account LIMIT 1].Full_Address__c;
System.debug('accountAddress '+accountAddress);
Account acc = [SELECT id, Full_Address__c FROM Account where Full_Address__c =:accountAddress LIMIT 1];

```

Returns:

[![enter image description here](https://i.stack.imgur.com/wlYMw.png)](https://i.stack.imgur.com/wlYMw.png)

It means that the same value I am getting by query doesn't work as filter. Looks like a bug.

Formula:

```
ShippingStreet & BR() & 
ShippingCity & ", " & ShippingState & " " & ShippingPostalCode & BR() & 
ShippingCountry

```