Creating a sort where certain leading chars are ignored

[Ruslan Zasukhin]

On 6/25/10 6:48 PM, "jda" <jda at his.com> wrote:

>> On 6/25/10 2:42 AM, "jda" <jda at his.com> wrote:
>> 
>>>  And also, how can I make this case *sensitive*?
>> 
>> This is controlled by
>> 
>>     fld.Collation( kStrength ) = kPrimary  or  kSecondary  or ...
>> 
> 
> But won't that make the sort case sensitive? I don't what that. What
> I want is for the "words to be ignored" search and deletion to be
> case sensitive. The sort of the field returned by the method should
> be case sensitive.

Ahhh,

Hmm,  may be you can make helper tmp field or Stored procedure
Which will have case sensitive settings and do TRANSFORTMATION of value,

And main tmp field-method which will have other collation settings ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]