I have to write a query on a positively atrocious table (this is with MSSQL 2005). Basically, multiple "lists" are stored in a single gigantic table called "UserData". I'm building the SQL statement ...

I have a large database of documents. Among the fields in each document are:<BR><BR>DocID (unique key)<BR>Relevant (one of five values)<BR>Topic (zero to all of twelve values - shown to me as a single ...

In Visual Basic I'd write this: If stringVariable IsNot Nothing then Dim x as Integer x = stringVariable.Length End If I test the string for null/nothing because if I try to get the Length of a ...