Optional Prompt macro

[mrcool]

Hi All,
The following macro is failing could you please help me in resolving the single quotes in pretext.

#promptmany('QuoteMethod',
'token',
' ',
'AND (Case When Quote_Assess.QUOTE_COUNT=1 Then 'Single Quote' Else 'Competitive Quote' End)  IN (', '', ')'
)#

Thanx in adavance

Cheers
Mrcool

[CognosPaul]

You can use the SQ function to wrap the strings in quotes.

#promptmany('QuoteMethod',
'token',
' ',
'AND (Case When Quote_Assess.QUOTE_COUNT=1 Then ' + sq('Single Quote') + ' Else ' + sq('Competitive Quote') + ' End)  IN (', '', ')'
)#