You have already posted this question -
How Do I Make It In The Same Row I,E I Want To Remove Null Values How Do I Do That?[
^]. Please do not repost.
I have already shown you how to get rid of the NULL values in this query in my response to your question
please correct the querry[
^]
To be clear - you need to use
ISNULL
i.e.
SELECT COMPOUND_NAME, [DATA_TYPE], [PLATE_ID],
ISNULL([500],0),ISNULL([300],0),ISNULL([100],0),ISNULL([30],0),
ISNULL([10],0),ISNULL([3],0),ISNULL([1],0),ISNULL([0.3],0),
ISNULL([0.1],0),ISNULL([0.03],0),ISNULL([0.01],0)
FROM [AFileStorageDB].[dbo].[COMP_CONVALUE]
This will replace the null values with zeroes.
I also showed you what was wrong with your query on the same solution
Quote:
The reason you are getting multiple lines of COMPOUND_NAME 7977797 (for example) is because you have included [WELLPOSITION](for whatever reason you did not show that column in your actual results).