filopastrymaker

Searching for UK postcodes

Discussion created by filopastrymaker on Dec 13, 2016
Latest reply on Dec 13, 2016 by David Moyer

FMPro 11

 

If I want to search for a UK postcode in an existing database eg AB12 3CD, how can I search for any variation AB123CD, AB1 23CD, AB12 3CD?

 

I am aware of the TrimAll function - TrimAll( Postcode ; 1 ; 3 ). Is there a way to include this in a Find request ?

Outcomes