Select localized values for a property that is not localized

The locale function is used 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