How can we help you today? How can we help you today?

ignore NULL <> '' fields?

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
0

Comments

4 comments

Sort by
  • jonathanhart
    hi guys - can anyone help me with the first post? I'm a paying customer btw!
    jonathanhart
    0
  • Brian Donahue
    Hi Jonathan,

    Does using the 'trim trailing spaces' option in the program help?
    Brian Donahue
    0
  • 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?
    jonathanhart
    0
  • 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
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.