Using ADO 2.7, what is the best way to perform a case-sensitive filter? I have seen on other forums where folks have said that the StrComp function can be used inside of the .Filter method, but I haven't been able to get that to work. I am using VB 6 and ADO 2.7, and have a need to perform case sensitive filters. I know I am not the ony one who has needed to do this...
As always, your time is appreciated.
YOu you mean client based filtering or a server based (used SQL Server in the backend) ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||I am attempting to do client sider filtering. The SQL Server installation has been installed to be case insensitive. I want to perform case sensitive filtering on my client side, disconnected recordset.
Your time is appreciated!
Thanks,
Langley111
|||
I thought of that :-) then you better post your question to one of the VB6 forums on the internet as they are more related to the problem than the SQL Server forums.
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment