I have created a filter to check when a user adds an attachment to look for
certain characters in the filename.
My set fields is reading from SQL as follows:
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) > 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) > 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) > 0))
This works fine, however, the problem is even attachments I had without those
certain characters still returns a value of 1.
Can someone tell me is there something wrong with my SQL statement?
Any feedback / help would be greatly appreciated!
Thanks.
----- End forwarded message -----
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
