Syntax substitution

Note the following:

• The Datatype argument is set to token, which means that the user-provided value is entered without any checking on the provided value.

  Because checking is not performed on the value, the expression editor may indicate that the expression is not valid. When a valid user-provided value is supplied or if you provide a valid default value, expression editor will interpret the expression as valid.

• Token should be used only if there is a list of pick-values for the user.
• The DefaultText argument is specified. Therefore, this is an optional prompt and group by COUNTRY is used in the generated SQL.

Select 
	COUNTRY_MULTILINGUAL.COUNTRY_CODE as COUNTRY_CODE,
	COUNTRY_MULTILINGUAL.COUNTRY as COUNTRY,
	COUNTRY_MULTILINGUAL."LANGUAGE" as LANGUAGE1,
	COUNTRY_MULTILINGUAL.CURRENCY_NAME as CURRENCY_NAME 
from 
	gosales.gosales.dbo.COUNTRY_MULTILINGUAL COUNTRY_MULTILINGUAL	
#prompt('Sort column',
			'token',
			'group by COUNTRY',
	'group by '
)#