Prompt that adds text before the syntax

Note the following:

  • This example uses the TextFollowing argument.
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
#promptmany('Selected CountryCodes',
				'integer',
				' ',     // < = = this
is a space
				'where COUNTRY_MULTILINGUAL.COUNTRY_CODE IN
( ',
				'',
				')'
)#