On 19 Aug 2015, at 2:00pm, R.Smith <rsmith at rsweb.co.za> wrote: > Seriously though, if that column is not COLLATE NOCASE declared, 'PZZZ' will > fail. Either ensure your column has COLLATE NOCASE or perhaps simply choosing > the highest (non UTF-8) character such as: > > WHERE name BETWEEN 'P' AND 'P~' > > will suffice.
Both good points about what I wrote. In fact the OP should do both. Simon.