Myles Wakeham wrote:

> ... I need to provide a search on a partial match
> (ie. 'LIKE' or 'CONTAINS' type search)

CONTAINING is case insensitive.

Regards