An escape character retains its special meaning within square brackets, unlike the wildcard characters. Do not use existing wildcard characters as escape characters in the escape clause, for these reasons:
If you specify “_” or “%” as an escape character, it loses its special meaning within that like clause and acts only as an escape character.
If you specify “[“or “]” as an escape character, the Transact-SQL meaning of the bracket is disabled within that like clause.
If you specify “-” or “^” as an escape character, it loses the special meaning that it normally has within square brackets and acts only as an escape character.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
