DB Tool Returns a Value of 0

reactancexlreactancexl Posts: 135

I have a situation where I am comparing a Source DB Table (SQL Server) to another DB exposed thru a REST API. I get the data from souce and pass in query to the API to get the result and then do a diff on message. That part is working fine, however if the source column is of Datatype Integer and is Blank, SOATest returns a value of 0. This caused issues. I have done the isnull and cast to varchar to get result which works but the full xml tag is my isnull value I need it to be . Any quick suggestions? .thx

Sign In or Register to comment.