Personally.... I go for storing the queries in the database itself if I can... in cases where that isn't feasible for what ever reason, I use StringBuilder...

Additionally, I will try to use parameters when possible... that eliminates confusing code, and eliminates the need for things like quoting functions. I should just be able to plug the data in... I shouldn't need to fiddle with it.

-tg