Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 15 Sep 2004 @ 08:49:51 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: UDF's without using C
From:   David Clough

Thanks for the examples, they work a treat! (I have to confess, I didn't know you could use a negative position).

Anyway, as to why anyone might want to do this, we have a town name that we also store as reversed. This was done before my time but I'm guessing that it might (depending upon the data) minimize the number of hits from a search.

For example, I would imagine that, taking my surname as an example, fewer entries from a search of 'HGU' would be returned as opposed to 'CLO'.

Anyway, it was just an example on UDF's which was my main point.

Dave Clough
Database Designer
Database Design Group

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023