Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've got load fields with values I want to exclude eg "#Null!","9", etc. Can one do this for individual fields?
Any help thanks,
Racine62
1)
Select * from ...
Where Field1 <> null and Field1 <>'9' and Field2 <> '4'
Load data wher Field1 is not null and will never contain value 9 and field2 will never contain value 4
1)
Select * from ...
Where Field1 <> null and Field1 <>'9' and Field2 <> '4'
Load data wher Field1 is not null and will never contain value 9 and field2 will never contain value 4
Thanks for this,
Regards,
Racine62