Thanks Mark for clarifying.
Kind regards
Bhavbhuti
On 16/02/2013 08:58 pm, Mark Rotteveel wrote:
>
> On 16-2-2013 15:52, venussoftop wrote:
> > Hi all
> >
> > When using LIKE I can use the 'String%' to look for partial matches.
> Not so when I want to use IN ('String%', 'VariousString%') instead I
> have to use 2 LIKEs
> >
> > Is there something I missed for using IN ()? That would allow me to
> use partial matches? The IN keeps the query simpler and shorter than
> multiple LIKEs IMO.
>
> You didn't miss anything. You need to see item IN (itemlist) to mean
> "does itemlist contain a value equal to item": it does not support
> partial matches! You either need to use multiple LIKE or STARTING WITH
> statements, or use the regular expressions introduced in 2.5 with
> SIMILAR TO, although multiple LIKEs are probably more efficient.
>
> Mark
> --
> Mark Rotteveel
>
>
--
Thanking you.
Yours Faithfully,
For Venus Software Operations
----
Mr. Bhavbhuti Nathwani
___________________________________________
Softwares for Indian Businesses at: http://www.venussoftop.com
[email protected]
[email protected]
___________________________________________
Please note: We reserve complete rights for policy changes in the future and
the same will be applicable immediately as and when made. Attachments may get
corrupted before reaching you, in such a situation please let us know and we
will resend you the same at the earliest. We do not take any responsibility
for data loss of any type and kind. Data safety remains the sole the
responsibility of the users of our softwares.
___________________________________________
Internet email confidentiality:
This message may contain information that may be privileged or confidential.
If you are not the addressee nor are you responsible for the delivery of the
message to the addressee indicated in this email, then you may not copy or
deliver this email to anyone and you should notify the sender by reply email
and then destroy this message.
Please reply email immediately to this message with REMOVE in the subject, if
you or your employer do not consent to email of this kind.
Opinions, conclusions and other information in this message that do not relate
to the official business of my firm shall be understood as neither given nor
endorsed by my company.
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
