Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-21 : 22:31:43
|
Phil writes "Hi Sean,
I am a bit new to the ADO game but I consider myself to be resonable enough to warrant a "Stump the Guru" question.
I have worked with JETSQL on Access databases for a few months now and have found it a very simple process. Now I am using an ODBC / ADO connection to a csv file (extract from non ADO compatible database) and my SELECT WHERE queries are case sensitive !! arg !! I cannot find any reference to this issue on MS technet.
I guess I can shoot the recordset into an ARRAY and UCASE it all - but I thought maybe I am doing something wrong and I can still select the recordset using a regular expression or equivalent ???
Thanks in advance.
Regards Phil ..." |
|
|
|
|
|
JetSQL and the Microsoft ODBC Text Driver