In urgent need of some help here guys
I need to join a SDE table to a local DBF file and you would think this is a piece of cake ..
SDE REGISTER_NO (CHAR(13)) -to-> DBF REG_NO (CHAR(13))
â€¦ the problem is that Oracle allows the CHAR(13) field to contain a space at the end of the field â€¦ dbf as far as i can tell, does not.
so I have something like
SDE :: â€˜ 0217400624 â€˜ trying to join to
DBF :: â€˜ 0217400624â€²
which of course, produces no results.
I do not have access to SDE to create a temporary VIEW to change the SDE format, so i am limited to
- somehow making ArcMap append the space to each record before doing the join
- somehow forcing the DBF to stop right trimming the space or
- somehow doing a partial match in ArcMap
Proper SQL tools please!!
If anyone knows how to do this with ArcObjects or any other method, PLEASE let me know as i am hoping i am just missing something obvious.