DaveC426913 wrote: Did you mean *I do* or *I do not* have to? You *do*. the variable cmd is a string. Therefore, you have to turn whatever you pass through into a string, to make it part of the string command. DaveC426913 wrote: It doesn't. It chokes trying to parse that line of code. This isn't a db problem, it's a VB problem. OK, in that case, VB isn't magically turning your boolean into a string, call it's .ToString method to get what you need. DaveC426913 wrote: Well, I have to change T/F to 1/0, which is what I'm doing. Query Analyzer needs a 1 or 0, not true or false ? In that case, does VB support ? : notation ? As in myBool ? 1 : 0, returns 1 if myBool is true, otherwise returns false ? DaveC426913 wrote: A thought: Should my structure have a get/set that automatically converts between T/F and 0/1? I'd try to do it inline. Or, if you used stored procedures, you can pass them a bool as a parameter, and the SP will turn it into what is needed. That's what I do, which is why I wasn't sure if SQL Server accepts true/false as bit values. Christian Graus - Microsoft MVP - C++