With one exception, DB2 UDB considers all zero-length character strings as equal to a single space. Therefore, it considers "" and a string of blank spaces to be the same thing.
The exception is as follows: DB2 UDB considers "" and " " to be different when you use them with the BEGINS function. For example, when you use the following statements to access DB2 UDB through the DataServer, the first statement retrieves all records from the customer table, but the second retrieves only those records in which the name begins with a blank character:
