Creating the correct SQL statement

ideas?? (if I haven't confused you already!) ;-)   Thanks in Advance   Craig Atkins Web Developer Sire Technology Ltd. +44 (0) 1344 758700 http://www.sire.co.uk   * This e-mail and its contents are confidential and are for the use

Problem with MySQL ASP

Hi I am running the latest versions of MySQL and MyODBC on my windows 200 webserver. I am trying to connect to my database and pull out some simple data with asp. The code i am using is: % dim db dim strConn dim rs dim QueryStr QueryStr = "SELECT * FROM imagedata" strConn = "mediaSafe"

How To Generate The SELECT statement I need

mean "John" or "LittleJohn" How can I do this in MySQL? How can I make it case sensitive or insensitive. Thank You For Your Help, Craig Atkins * This e-mail and its contents are confidential and are for the