Query.getWhere().isLike("person","lastname","#ucase(lastname)#)

[Nathan Stanford Sr]

Query.getWhere().isLike("person","lastname","#ucase(lastname)#)

How can I make it case insensitive?

I know this will not work but what do I need to do to make sure when someone searches it will find the correct person.

Query.getWhere().isLike("person","UPPER(lastname)","#ucase(lastname)#)

Thanks,

Nathan

[Tom Chiverton]

On Mar 29, 8:17 pm, Nathan Stanford Sr <nathan.stanf...@gmail.com>
wrote:

> Query.getWhere().isLike("person","lastname","#ucase(lastname)#)
>
> How can I make it case insensitive?

There should be a isLikeNoCase() ?

Tom