I am using DB tool to retrieve data from SQL Server.
In DB the value is 0.0000003 but while returning in soatest it shows as below
Not sure about the conversion.Could you pls check and confirm.
Isn't 0.0000003 is the same as 3.00000E-7? I don't think the database stores the value as text but as a floating point number. So, neither textual representation is incorrect.
If, for example, you want to validate a floating point value then you could do a numerical comparison (not a text comparison). You could do this with the "Numeric Assertion" from the XML Assertor, for example.