How to specify parameter marker characters (Enterprise Manager)

To specify parameter marker characters

1. Right-click in any pane of the Query Designer, and then from the shortcut menu, choose Properties.
2. In the Properties dialog box, choose the Parameters tab.
3. Enter the parameter prefix character or characters and, if you intend to use one, a suffix character. (You can specify a suffix character only if you have specified a prefix character.) If you need to specify one, enter an escape character.