ODBC Server Reference Manual

Summary of Support for SQL Server Features

HP NonStop ODBC Server Reference Manual—429151-002

B-28

Wild-Card Characters

The NonStop ODBC Server supports two of the SQL Server wild-card characters.

When used with the NonStop ODBC Server, the % wild-card character works

differently than it does in SQL Server:

•

In the NonStop ODBC Server, character comparisons are not case sensitive; in

SQL Server, they are case sensitive.

•

Because NonStop SQL/MP recognizes trailing blanks as part of a string, you must

place the % wild-card character at the end of a comparison; this is not necessary in

SQL Server.

For detailed information on wild-card characters, see Wild-Card Characters on

page 4-33.

Table B-10. NonStop ODBC Server Support of Wild-Card Characters

SQL Server Wild-Card

Character NonStop ODBC Server Support

[ character-range ]–

[ character-set ]–

[ ^character-range ]–

[ ^character-set ]–

x Indicates a supported wild-card character

– Indicates an unsupported wild-card character