V4MD "Search a string case insensitive ..."

[Erik Scholtz]

info at vallemediatime.com wrote:
> I try to ask again...
> It's so hard to answer?  :-)
> Paolo
> 
> ----- Original Message ----- 
> From: <info at vallemediatime.com>
> To: "Valentina Developers" <valentina at lists.macserve.net>
> Sent: Friday, July 08, 2005 11:55 AM
> Subject: V4MD "Search a string case insensitive ..."
> 
> 
> Hi Ruslan and Igor,
> I've not found the request example (Mantis #881)
> "Search a string case insensitive in all one table in V4MD"
> where have you put it?
> Thanks
> 
> Paolo

Hi,

I don't know where the example is, but try something like this:

SELECT col1,col2,col3
FROM table
WHERE LOWER(column4)=LOWER('seArchString')

This will make the search case-insensitive. Perhaps there is an option 
on valentina I don't know, but I think this is a easy, working way.

Best regards,
Erik