ignore NULL <> '' fields?

jonathanhartjonathanhart Posts: 4
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


Jonathan Hart


Sign In or Register to comment.