Thank Simon, I have looked into using a user defined function however it was very slow. I tried to create an expression index unfortunately I was not able as the function was seen as non deterministic. (I am using the C# interface and its not possible to define a user defined function as Determinstic from C# (Feature request!?))
Thanks Brian -- <http://www.thinksmartbox.com> www.thinksmartbox.com Facebook <https://www.facebook.com/thinksmartbox> Twitter <https://twitter.com/ThinkSmartbox> LinkedIn <https://www.linkedin.com/company/smartbox-assistive-technology> YouTube <https://www.youtube.com/user/SmartboxAT> Smartbox Assistive Technology, Ysobel House, Enigma Commercial Centre, Sandys Road, Malvern, WR14 1JJ Tel: +44 (0) 1684 578868 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users