ignore NULL <> '' fields?

jonathanhart

hi all - I just recently downloaded & purchased the latest SQL Datacompare 5 program.

I'm trying to compare data that is put into a SQL 2000 database from 2 different sources - one of them always inititialises varchar fields as an empty string - the other leaves them as NULL.

Is there anyway for me to 'ignore' the differences? (i.e. treat NULL & an empty string as the same for comparison purposes?)

many thanks in advance

cheers

Jonathan Hart

jonathanhart

hi guys - can anyone help me with the first post? I'm a paying customer btw!

Brian Donahue

Hi Jonathan,

Does using the 'trim trailing spaces' option in the program help?

jonathanhart

Hi - thanks for the reply - but I'm afraid I already have the 'trim trailing spaces' option ticked

any other ideas? or might we see this as a new option in the future?

Brian Donahue

Hello,

Trim trailing spaces was designed to solve this problem, but I suppose it may be a good idea to test whether or not it is affected by differing collation orders, etc