Skip to Content
0
Former Member
Jun 07, 2010 at 05:26 PM

Matches pattern/Different from pattern with underscores doesn't work

97 Views

This is the query i have used.

REPLACE (upper (TICKET.ORG_GROUP), '_', '#') LIKE REPLACE (upper(@Prompt('Enter Org Group in upper case - use % as a wildcard or ALL for any value:','C',,Mono,FREE) || '%'), '_', '#') OR ('ALL') IN @Prompt('Enter Org Group in upper case - use % as a wildcard or ALL for any value:','C',,mono,FREE)

requirement should be: 1)If the user enter the value EV_ value should be EV_

2)if the user enter EV_% mean then value should be EV_123,EV_RM,etc

3)if the user enter the %EV_ mean then value should be RVEV_,123EV_ etc

4)if the user enter the %EV_% mean then all value that contain 'EV_'should come.

now (if the user enter the %EV_ mean then value should be RVEV_,123EV_)

this one is not working only EV_ is coming.

i dont know how can fix this issue,

But it currently provides:

EV_xxxx

LVEV_xxx

123EV_xxxx

Etc

Which is what I would expect with %EV_%.

I also need EV% to provide:

EV_xxxx

As well as...

EVxxx

can you plz give me other query or how can i fix