Archives of the TeradataForum
Message Posted: Fri, 09 Feb 2007 @ 21:55:15 GMT
Your situation is not unusual but the phrase "I am an end-user and cannot make decisions regarding new installations." strikes me as too pessimistic. The database is for end-users so they should decide what they want to do with it, no?
Having said that, the UDF threshold might be too high for an ad hoc request of one user. Compiling C code was not something end-users used to do on a regular basis over the last 10-15 years.
Yes. But before I describe them I'd like to mention that you can customize collation rules and define your own collation. Once you choose it for your session you can effortlessly compare strings according to your rules. I'd say it is the most natural solution in this situation but it does require some admin effort. Perhaps more effort than with UDF as customized collations are exotic.
Non-admin method would be to use the brute force and convert your data character-by-character and store it somewhere for further analysis. SUBSTRING and CASE should do the business if you give them enough time. Not elegant but doable.
Anyway, good luck with this, and keep us posted.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|