Originally posted by Shadow88
Now it is generally common knowledge that if you project sound waves at a note of C, at a glass with a resonant frequency of the note C, long story
short the glass will vibrate and shatter.

Folk knowledge, maybe, but no truth to it. You'd find that different frequencies shatter glass, depending on what else is in the glass (impurities)
and how thick it is and what its shape is, and so forth.

Now if say.......for example if sound waves are projected in a certain way.....would it be possible to create a pillar of water???

Nope. There's limits to the height that a column of water can rise. Even vortex columns (waterspouts) only have a certain limit in height. Nor is
there any way to focus sound tightly into a column. It tends to form cone shapes.

Or could you pour nanobots (when the technology is advanced enough obviously) into the water, each one designed to latch on to water droplets.
When these nanobots interact they could make water rise up in a pillar or as a snake thing (im thinking of the film "Abyss")

In science fiction films (particularly in films) where the producer and scripter are not necessarily faithful to science, ANYthing can happen. While
many of us think that they could make far more exciting pieces following what would really happen ("10" comes to mind with its overblown script and
truly terrible science), sadly, some of them will abandon good science for theatrics.
In this case, "probably not." You're looking at height versus weight and stability and anything over about 32 feet needs a lot of support. It'd
probably just sink.