update a duplicate record - case sensitivity

[ai3rules]

Hi all,

I am checking for duplicates when updating a record using the following basic method.


modifyFieldQRY = "SELECT * FROM "&table&" WHERE "&order&"='"&modFieldName&"'"
compareModifyTable.open modifyFieldQRY, oConn
if not compareModifyTable.eof then
duplicate
end if
if compareModifyTable.eof then
update record
end if


That works fine. My only issue is, if for example I want to update the value "hello" to "Hello" it considers it a duplicate.

Is there a way to treat those two strings different based on case sensitivity?

Thank you in advance for any help.

[Master Shake]

In MySql I believe there is a BINARY keyword that you can use in the query to make it case sensitive.

SELECT whatever FROM someTable Where BINARY password = 'myPassword'

No reference right in front of me so not sure that is totally correct but can be looked up for syntax if you use MySql.


Don't know if that works for SQL SERVER so here is a link for that one: http://www.aspfaq.com/show.asp?id=2152.

Anything else I am unaware of how to fix, but I'm sure it is somewhere to be found on google.

BaldEagle