Select localized values for a property that is not localized

You can use the locale function to select localized values from the source object. The number of positions defines the total number of numbered columns returned in the results. The property is not defined as a localized property in the metadata.

The result is the position number columns. The single string value found in the data object is returned as the value of position_1. The remaining position columns are empty.

SELECT locale(property, number of positions) FROM object