Problem Note 9317: Using the LIKE condition with an escape sequence against an indexed
column returns 0 matches
Zero matches are found when using the LIKE condition with an escape
sequence against an indexed column.
If the column is non-indexed the LIKE condition returns the proper
results.
The ESCAPE option for the LIKE condition was introduced in Release 8.2
of SAS. Trying to use the ESCAPE option in releases prior to 8.2 results
in an error condition.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009317
Operating System and Release Information
| SAS System | Base SAS | CMS | 8.2 TS1M0 | 8.2 TSM1 |
| 64-bit Enabled HP-UX | 8.2 TS1M0 | 9.1 TS1M0 |
| Solaris | 8.2 TS1M0 | 9.1 TS1M0 |
| 64-bit Enabled Solaris | 8.2 TS1M0 | 9.1 TS1M0 |
| z/OS | 8.2 TS1M0 | 9.1 TS1M0 |
| Linux | 8.2 TS1M0 | 9.1 TS1M0 |
| HP-UX | 8.2 TS1M0 | 9.1 TS1M0 |
| Tru64 UNIX | 8.2 TS1M0 | 9.1 TS1M0 |
| 64-bit Enabled AIX | 8.2 TS1M0 | 9.1 TS1M0 |
| OpenVMS Alpha | 8.2 TS1M0 | 9.1 TS1M0 |
| AIX | 8.2 TS1M0 | 9.1 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> SQL
SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2003-06-20 15:22:29 |
| Date Created: | 2003-02-03 09:19:48 |
