Hello,

We are using VisualFoxPro 6.0 at the moment.

We want to create a SQL statement where we will get a result which does NOT show the .NULL. values of certain fields. We tried almost everything but I guess we are missing a small detail.

Could anybody give us an example of a SQL statement which will NOT show the fields which have a .NULL. value.

Thanks in advance!