SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted on Feb 21, 2008 - 6 answers 
Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted on Apr 18, 2007 - 9 answers
Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help. [more inside]
posted on Jan 31, 2007 - 20 answers
How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted on Jan 24, 2007 - 5 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted on Dec 13, 2006 - 3 answers
Help with MS Access needed please - I'm told it should be a fairly simple query to conduct, but I don't think I'm upto the task solo. Can the hive mind help? [more inside]
posted on Nov 18, 2006 - 12 answers
What is the easiest way to get this data into a MySQL database? [more inside]
posted on Nov 2, 2006 - 19 answers
I have a question about finding the longest sequence in a set of numbers. [more inside]
posted on Sep 2, 2006 - 13 answers
I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted on Jul 14, 2006 - 14 answers
Infuriating Microsoft Access questionfilter: I have a database that I inherited in which queries are set up to pull records which have dates of birth between certain dates. It works right in one database but is not working right in another, for a very particular reason.. [more inside]
posted on May 2, 2006 - 7 answers
I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports. [more inside]
posted on Feb 15, 2006 - 31 answers
How do I write arbitrary SQL queries in Ruby on Rails? [more inside]
posted on Dec 13, 2005 - 9 answers
I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted on Nov 29, 2005 - 18 answers
Database Query [+]
posted on Jan 24, 2005 - 11 answers
Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
posted on Apr 17, 2004 - 15 answers
