On 3/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote: > If I want to do "SELECT * FROM table WHERE field = value", > how can I do this matching text only and not case? >SELECT * FROM table WHERE field COLLATE nocase = value;
ahhh, I didn't know this could be done at SELECT time. I thought this had to be defined at CREATE TABLE time. Thanks for the clarification. Once again, however, it perplexes me how one could have found this out from the existing docs. The more that can be found from existing docs, the less folks will have to rely on the mailing list for help (hopefully). -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
