I want to execute the following query on compact but I know it doesn't have the collate function. I'm looking for another way to accomplish the below query with sql.
select CHARINDEX('a','ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'COLLATE Latin1_General_CS_AS)
I am very locked into this clients development tool and if I can't do this with sql compact I'm probably going to need to iterate each character of my string vs each character of my valid character set with the tool which is feasible but what I wanted to avoid.
Update
Ended up just iterating the two character by character. It also maybe have worked out to edit the schema of just column that contained the ABCDEFG....etc but I'm not sure if that would have flown in compact. Food for thought.