Adaptive Server truncates trailing blanks following “%” in a like clause to a single trailing blank. like ‘‘% ’’ (percent sign followed by 2 spaces) matches ‘‘X ‘’ (one space); ‘‘X ’’ (two spaces); ‘‘X ’’ (three spaces), or any number of trailing spaces.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
