Fields containing spaces only

[belvasis]

Hi,
i have a problem and don't know how to fix it. I have a Column that contains a single space character (' '). If i access the field via ZQuery the values is always empty (''). If i chagen the ' ' to any other character the value of the field is correct. The problem is, i need to know that the field contains a sapce character. Why is it not correctly retrieved.
The problem occurs while using MSSQL2000.
Thanks in advance for any comment or idea.