Where

[smilingjohn]

Hi All,

Iam using the where clause , can any suggest me if iam wrong . from dept iam trying to take only set and jet

where Dept_S='set' and Dept_S='jet' and not match(User,'A435\devt'):

Thanks

[Anonymous · Accepted solution]

Try

where match(Dept_S,'jet','set') and not match(User,'A435\devt');

[vinieme12]

TRY

where MATCH(Dept_S,'set','jet')>0 and match(User,'A435\devt')=0;

[smilingjohn]

I dont think so the match is required actaully the code was like this

where Dept_S='set' and not match(User,'A435\devt'):

now they want to show jet also , how do i go with this  .

[tresesco]

There are various ways you can use like with match() or without match().

You can replace your and with or like:

Dept_S='set' or Dept_S='jet' and not match(User,'A435\devt')

Note, you might have to put an additional brace like

(Dept_S='set' or Dept_S='jet') and not match(User,'A435\devt')

Depending upon your expected output

[vinieme12]

smilingjohn‌ have you tried the above?