Finding an Exact match using Select and Search prompt

[DJ]

Hi,
I am using Select and Search Prompt in my Cognos report and I wanted to know if it is possible to get only the exact match of the search string that I provide.
For eg: i search for 123 and i want only 123 to be returned. Now I'm all the below 3 values.
123
1234
12345

Thanks in advance,
DJ.

[cognostechie]

Right under the Prompt there are options. I don't have it in front of me right now but I remember there are options to specify what kind of match you want.

[DJ]

Only the following options are available, but not for selecting ONLY the exact string.

Starts with any of these keywords
Starts with the first keyword and contains all of the remaining keywords
Contains any of these keywords
Contains all of these keywords

But I want only 123 to be returned when I search for 123.
With any of the above options it is not possible.

Thanks,
DJ.

[dougp]

That's not what a Select & Search prompt is for.  Maybe you should be using a textbox prompt.