January 27, 2003 at 3:17 am
I am trying to import from a case sensitive system into a non case-sensitive SQL database. The import is fine but I need to cross reference to a table where codes in different cases hold different data (and I need to pick up the right set). I think perhaps I need to use Active-X but I haven't been able to get further than that. Does anyone have any ideas.
January 27, 2003 at 7:10 am
Could you show some code or schema or something to get things started...
January 27, 2003 at 7:46 am
Not as such but
I have two tables in an ingres database. I use post_no on one to link to post_no on another and return the description. What I currently do is read both tables into SQL using DTS and do the link there. (I need the tables for other things later as well). Although I can see a post 123A and 123a the link in SQL assumes that they are the same as I do not want my database to be case sensitive. As far as I know (yet) I do not need to have this case insensitive link elsewhere. I was wondering if I could use a lookup to populate the desciption correctly as i was bringing in the code as this uses Active-X and perhaps will allow me to link to the correct case only.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply