select * from users where [has_clue] =! null

0 rows affected.

Although my sql skills are improving considerably. I just ran a really funky report, something that would normally take about a half hour to run, in the space of about 8 seconds. Ah, the power of clustered indexes.

Also working on a script to automagically truncate large log files in a SQL system by trolling the system database to see what's a little too big. Only problem I'm having right now is how to get the quotes around the log file name, so I can pass a delete command to the OS. Despite using quotename() and various variations on (char(39) + (filename + char(39)), I'm still only able to get the first quote to show up. And anyone can tell you that Windows will reject that faster than most girls rejected me in high school. Good thing I had wide ranging tastes... :-)

Any help anyone can offer is appreciated. It's MSSQL 2000, by the way...

End of day. Time to pack it up. Later, folks.

-d.