https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69919#M22524 There isn't a BP value that corresponds to DBNull, so the best policy is to avoid returning DBNull from your query. For example SELECT ColumnThatCannotBeNull1, ISNULL(ColumnThatMightBeNull, '') AS ResultThatWillNotBeNull Thu, 26 Oct 2017 12:09:00 GMT John__Carter 2017-10-26T12:09:00Z https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69917#M22522 Hi guys, I'm just wondering if anybody has come across the DBNull issue? When returning data into a collection (via a sql query in my case), I have some null values, the problem I am facing is when I try do anything with that collection I get the "DBNull" error. Has anybody experienced this issue before? TIA Wed, 25 Oct 2017 16:09:00 GMT https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69917#M22522 DhirenPatel 2017-10-25T16:09:00Z https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69918#M22523 DBNull means that the record in the database does not contain a value. Have you tried changing your query to not output null values? something like, SELECT Field FROM Table WHERE Not(Field) is null; Thu, 26 Oct 2017 10:12:00 GMT https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69918#M22523 Anonymous 2017-10-26T10:12:00Z https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69919#M22524 There isn't a BP value that corresponds to DBNull, so the best policy is to avoid returning DBNull from your query. For example SELECT ColumnThatCannotBeNull1, ISNULL(ColumnThatMightBeNull, '') AS ResultThatWillNotBeNull Thu, 26 Oct 2017 12:09:00 GMT https://community.blueprism.com/t5/Product-Forum/DBNull/m-p/69919#M22524 John__Carter 2017-10-26T12:09:00Z