>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!

You can use NVL() function:
sele NVL(field1,""),NVL(field2,0) from mytable