Why LIKE operator in prompt gives error

building semantic layer
1

Hi,
I want to achive this in the universe prompt
select clientname from client where clientname LIKE ‘a%’

i tried this in prompt but parse fails with error ('Incorrect syntax near ‘,’ ').
@Select(Client Attributes\Client Code) LIKE @Prompt(‘Enter Client Code:’,‘A’,MULTI,FREE)

This gets parse succesfully
@Select(Client Attributes\Client Code) IN @Prompt(‘Enter Client Code:’,‘A’,MULTI,FREE)

Does this mean we can not use LIKE in Prompt?

Baapu (BOB member since 2008-05-16)

2

If you use LIKE you must use MONO. The like operator will only work with a single value to compare to.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

WOO HOO It worked!! Thank you so much.

Baapu (BOB member since 2008-05-16)