Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with ID 01, 001, and 0001
I have another Table using one of those IDs. when I join the tables I see all three joined. Is there a way around this?
Use Text(ID) for join, in both table.
regards
unfortunately, this did not work. Is there another way?
What about this:
Replace ('ID','0','X') as NewID
In both table.
Did you try Text(ID) in the load script from the original source?
What is the source?
the data is coming from a qvd File.
Use Autonumber(ID) AS KeyID