I have a table that has a varchar column. The column contains a single character which is a percent sign (%). If I try to use the AssertEqualsTable with that table it throws an error message:
[testSchema].[test that this worked] failed: (Error) Invalid format specification: '% |!NULL! |!NULL! |!NULL!|!NULL! |!NULL! |
|> |2 |!NULL! |!NULL! |!NULL! |!NULL!|% |!NULL! |!NULL! |!NULL!|!NULL! |!NULL! |'.[16,1]{tSQLt.Fail,52}
If I change my test to validate the other columns and exclude the column that contains the percent sign, the test works.
Can this be fixed so that it can accommodate this character in the table?