[V4MD2] Are queries case sensitive

[Scott Runkel]

> The reason I asked this question is because my results from my SQL query
> would indicate otherwise.  I have a WHERE clause that looks at the last name
> of "smith" I get no records returned, same query using "Smith" returns all
> of the Smiths.  Can you please explain why that would be?  Do I need to set
> the ColAttribute or something else?

As far as I can tell, queries ARE case-sensitive in V4MD. I have to add a
"NO_CASE" to my queries to get around this.

-SR

Scott Runkel
Director of Technology
Hypix Media, Inc.
503-722-2123