Re: Whatcha' wanta have?????

Mark D. Stock wrote: > > Can't this be achieved using functional indexes? ummmmm, we'd have to deliver 9.X to all customers....

"Andrew Hamm" <ahamm@mail.com> wrote ... > Mark D. Stock wrote: > > > > Can't this be achieved using functional indexes? > > ummmmm, we'd have to deliver 9.X to all customers.... and we'd have to change ALLLLLLLL the code to have something like and upshift(cats_name) = upshift(?) instead of and cats_name = ? wouldn't we? I've not used functional indexes before (note to self...) but my understanding is that the engine needs to recognise an expression that is solvable with the index as it was defined. Also, can a functional index solve this? and cats_name matches "tidd*l*s" See, we want case to be ignored. SOMETIMES. When we ask for it ONLY. Without having to rewrite lots of code.

Andrew Hamm wrote: > > Also, can a functional index solve this? > > and cats_name matches "tidd*l*s" > That example would be better with and cats_name matches "*tidd*l*s" so that it finds these records: Tiddles TIddles tiddles TIDDLES Mr Tiddles Sir Tiddles Tiddlz