Prompt that appends text to the value

Note the following:

• The DefaultText argument is specified as a space character. In this case, the generated text is just the space character, which eliminates the Where clause from the query.
• The Text argument is specified, which is written into the generated SQL before the user-provided prompt value.

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('Starting CountryCode',
		'integer',
		' ',          // < = = this is a space
	'where COUNTRY_MULTILINGUAL.COUNTRY_CODE >'
)#