Indexing with Upper and Lower case seperation

[TheRealDeal]

Is there any way to UNIQUE index on the upper and lower of a field?

i.e.
FontTable FontLetter
1A A
1A a
1A B
1A b
and so on...

 

[KenReay]

Hi

A pure guess, becuase I have not tried it, but how about defining the field in the table as byte or integer, index on that, and when you want to see it is a character, have a query with a calculated column of chr(MyInteger) Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[TheRealDeal]

I am needing to keep the field in a Char(Text) format only for the fact it truly is a Char representation in a Font Table. History: I am pulling together the BMPs that go into a Font via a Font creator. Given that, I need to reference the the BMPs by single Characters. These Characters must be upper and lower case to make the whole thing work. In general I am getting 52 BMPs in each Font; otherwise, if I use the entire Font range I would end up with a VERY huge file.