I want to test for case-sensitive data on a case-insensitive database (ASA 8.0). I can't create a new database. I connect from my XP box using dbisqlc, passing cs 'cp850'. Further, I try:
begin
Declare @Temp VarChar(50);
Set @Temp = csconvert('UPPER CASE Words only','cp850');
Select SubString(@Temp, 1, Locate(@Temp, CSCONVERT('w','cp850'),1)+1);
end;
I still get 'UPPER CASE Wo' as a result. Any ideas?
begin
Declare @Temp VarChar(50);
Set @Temp = csconvert('UPPER CASE Words only','cp850');
Select SubString(@Temp, 1, Locate(@Temp, CSCONVERT('w','cp850'),1)+1);
end;
I still get 'UPPER CASE Wo' as a result. Any ideas?