Address () Function

This FH function lists a formatted address (combines street prefix, street name, street type, and street suffix). For queries, we recommend that you do not use the Address() function as the function uses the first encountered address to determine a length, and subsequent addresses with a greater length will be cut off.

To use this function in a query without cutting off formatted address information, use PADR () with ADDRESS () to ensure that space is allocated for all address information.

Example: PADR(ADDRESS(),50), and this would always include up to 50 characters of address information.

You can specify up to 254 characters if necessary.  

For details on using this function, see the Expression Builder form Advanced section, highlight the function, then press Details.

 

Related Topics: 

• Expression Builder Advanced Section