Ah ...
An update to this question... probably the cause is a test that I do before I issue the sql:
I test the old and the new name for differences
So my test is:
If newname <> oldname then ... (update)
but ... if oldname= 'good' and newname = 'Good' these are considered the same.
I could change the default compare setting for the whole database to Option compare binary
but this is not desired in other situations.
What is the best way to do a case-sensitive string comparison?
Onno
__._,_.___
Posted by: onno.knol@pbl.nl
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar