LIKE predicate available for Oracle and SQL Server ???

Georg Peter

LIKE predicate available for Oracle and SQL Server ???
Hello Listers,

The LIKE predicate, a SQL-92 standard, works very good within DB2 for
OS/390.

My question: Is LIKE supported by Oracle (8.0.5 and higher) and SQL Server
also ? And if the answer is yes, are there any pitfalls ?

Thanks in advance for any help you can offer.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Technology & Development Center
Knowlegde Center DB2
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

"Experience is something you don't get until after you need it." - Anonymous



Steve Tennant

Re: LIKE predicate available for Oracle and SQL Server ???
(in response to Georg Peter)
****************************************************************
IMPORTANT

The information transmitted is for the use of the intended
recipient only and may contain confidential and/or legally
privileged material. Any review, re-transmission, disclosure,
dissemination or other use of, or taking of any action in
reliance upon, this information by persons or entities other
than the intended recipient is prohibited and may result in
severe penalties. If you have received this e-mail in error
please notify the Privacy Hotline of the Australian Taxation
Office, telephone 13 2869 and delete all copies of this
transmission together with any attachments.

****************************************************************
Supported by both AFAIK. Don't know of any pitfalls in Oracle.
As to SQL Slower, I've not used it in depth but I'm sure someone
else on the list will let you know if there are problems.

-----Original Message-----
From: Peter, Georg [mailto:[login to unmask email]
Sent: Thursday, 14 December 2000 21:07
To: [login to unmask email]
Subject: LIKE predicate available for Oracle and SQL Server ???


Hello Listers,

The LIKE predicate, a SQL-92 standard, works very good within DB2 for
OS/390.

My question: Is LIKE supported by Oracle (8.0.5 and higher) and SQL Server
also ? And if the answer is yes, are there any pitfalls ?

Thanks in advance for any help you can offer.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Technology & Development Center
Knowlegde Center DB2
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

"Experience is something you don't get until after you need it." - Anonymous



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



Higgins John

Re: LIKE predicate available for Oracle and SQL Server ???
(in response to Steve Tennant)
The syntax for LIKE in DB2 6+ is identical to Oracle 8+. AFAIK it is also
the same in prior releases of both.

The only difference I know is that Oracle usually considers an empty string
to be the same as NULL and DB2 does not.

Best regards,
John P. Higgins
Performance Specialist
SAP BASIS Team

Deere & Company Voice: (309) 748-1625
Attn: GTTC East FAX: (309) 748-1605
One John Deere Place email: [login to unmask email]
Moline, IL 61265-8098

> -----Original Message-----
> From: Tennant, Steve [SMTP:[login to unmask email]
> Sent: Thursday, December 14, 2000 5:03 PM
> To: [login to unmask email]
> Subject: Re: LIKE predicate available for Oracle and SQL Server ???
>
> ****************************************************************
> IMPORTANT
>
> The information transmitted is for the use of the intended
> recipient only and may contain confidential and/or legally
> privileged material. Any review, re-transmission, disclosure,
> dissemination or other use of, or taking of any action in
> reliance upon, this information by persons or entities other
> than the intended recipient is prohibited and may result in
> severe penalties. If you have received this e-mail in error
> please notify the Privacy Hotline of the Australian Taxation
> Office, telephone 13 2869 and delete all copies of this
> transmission together with any attachments.
>
> ****************************************************************
> Supported by both AFAIK. Don't know of any pitfalls in Oracle.
> As to SQL Slower, I've not used it in depth but I'm sure someone
> else on the list will let you know if there are problems.
>
> -----Original Message-----
> From: Peter, Georg [mailto:[login to unmask email]
> Sent: Thursday, 14 December 2000 21:07
> To: [login to unmask email]
> Subject: LIKE predicate available for Oracle and SQL Server ???
>
>
> Hello Listers,
>
> The LIKE predicate, a SQL-92 standard, works very good within DB2 for
> OS/390.
>
> My question: Is LIKE supported by Oracle (8.0.5 and higher) and SQL Server
> also ? And if the answer is yes, are there any pitfalls ?
>
> Thanks in advance for any help you can offer.
>
> With kind regards - mit freundlichen Grüssen,
> G e o r g H . P e t e r
> DB2 Data Base Administrator c/o
> -------------------------------------------------------------------
> Datenzentrale Baden-Wuerttemberg
> Technology & Development Center
> Knowlegde Center DB2
> Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
> e:mail [login to unmask email]
> Phone 0049-711-8108-271
> PC-Fax 004971189696071
> Internet (only in german language):http://www.dzbw.de
> ----------------------------------------------------------------------
>
> "Experience is something you don't get until after you need it." -
> Anonymous
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



[login to unmask email]

Re: LIKE predicate available for Oracle and SQL Server ???
(in response to Higgins John)
Georg,

Oracle does support Pattern searches using the LIKE predicate. It's
format
and usage is just like DB2 and returns the same type of answer sets. I've
never used SQL Server so I can't answer that one.

Good Luck,
Don Alden

-----Original Message-----
From: Tennant, Steve [mailto:[login to unmask email]
Sent: Thursday, December 14, 2000 4:03 PM
To: [login to unmask email]
Subject: Re: LIKE predicate available for Oracle and SQL Server ???


****************************************************************
IMPORTANT

The information transmitted is for the use of the intended
recipient only and may contain confidential and/or legally
privileged material. Any review, re-transmission, disclosure,
dissemination or other use of, or taking of any action in
reliance upon, this information by persons or entities other
than the intended recipient is prohibited and may result in
severe penalties. If you have received this e-mail in error
please notify the Privacy Hotline of the Australian Taxation
Office, telephone 13 2869 and delete all copies of this
transmission together with any attachments.

****************************************************************
Supported by both AFAIK. Don't know of any pitfalls in Oracle.
As to SQL Slower, I've not used it in depth but I'm sure someone
else on the list will let you know if there are problems.

-----Original Message-----
From: Peter, Georg [mailto:[login to unmask email]
Sent: Thursday, 14 December 2000 21:07
To: [login to unmask email]
Subject: LIKE predicate available for Oracle and SQL Server ???


Hello Listers,

The LIKE predicate, a SQL-92 standard, works very good within DB2 for
OS/390.

My question: Is LIKE supported by Oracle (8.0.5 and higher) and SQL Server
also ? And if the answer is yes, are there any pitfalls ?

Thanks in advance for any help you can offer.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Technology & Development Center
Knowlegde Center DB2
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

"Experience is something you don't get until after you need it." - Anonymous



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]