That works perfectly Dylan. Thanks.
Although in some off-list emails I was told that it would probably not
work for Oracle, so lucky for me I use SQL Server.
Thanks again,
Shawn Pierson
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Monday, March 19, 2007 1:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: Putting a wildcard in a Run If
**
'Login Name' LIKE "s[_]%"
That should work. If you want to use a wildcard as a literal
then you put [] around it.
Dylan
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: Monday, March 19, 2007 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Putting a wildcard in a Run If
**
This is probably a simple, obvious thing, but I don't
remember a good way around this.
I'm setting up a feed for Remedy so I can pull over
logins. The problem is that I need to exclude service and admin
accounts from the feed since those logins will never be used in Remedy.
The problem is that they are prefixed with things like svc_, s_, etc.
The problem is that underscores are wildcards representing one
character. So, if I wanted to check for a "s_shawnpierson" account I
would first think to do a search for:
'Login Name' LIKE "s_%"
The problem is that since both the underscore and the
percent signs are wildcards, I am essentially searching for "s%", which
returns all logins that start with "s". Any suggestions on how I can
get around this?
Thanks,
Shawn Pierson
The information in this e-mail, and any files
transmitted with it, is intended for the exclusive use of the
recipient(s) to which it is addressed and may contain confidential,
proprietary or privileged information. If you are not an intended
recipient, you have received this transmission in error and any use,
review, dissemination, distribution, printing or copying of this
information is strictly prohibited. If you have received this e-mail in
error, please notify the sender immediately of the erroneous
transmission by reply e-mail, immediately delete this e-mail and all
electronic copies of it from your system and destroy any hard copies of
it that you may have made. Thank you.
__20060125_______________________This posting was
submitted with HTML in it___
This message and any attachments are for the intended
recipient(s) only and may contain privileged, confidential and/or
proprietary information about Downey Savings or its customers, which
Downey Savings does not intend to disclose to the public. If you
received this message by mistake, please notify the sender by reply
e-mail and delete the message and attachments.
__20060125_______________________This posting was submitted with
HTML in it___
The information in this e-mail, and any files transmitted with it, is intended
for the exclusive use of the recipient(s) to which it is addressed and may
contain confidential, proprietary or privileged information. If you are not an
intended recipient, you have received this transmission in error and any use,
review, dissemination, distribution, printing or copying of this information is
strictly prohibited. If you have received this e-mail in error, please notify
the sender immediately of the erroneous transmission by reply e-mail,
immediately delete this e-mail and all electronic copies of it from your system
and destroy any hard copies of it that you may have made. Thank you.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
