Hi I am not sure if this is the correct forum to be asking this in. But I am using VS2008 and am using a DNN module to pull school information from a datbase to display on the page. Currently the code below is displaying name, city and state AS SCHOOLNAME on the school search page.

http://prepsonthenet.com/dnn/Schools/tabid/387/Default.aspx

I am looking to add another field after the city in this string. The issue I am having is that the field in the database is a checkbox and only some are checked. So basically if the field is checked in the database I want to display a '*' on the page if the value is checked/true. I am able to pull any other normal text field from the database to display just have the issue with the checkbox. I am not sure if that all makes sense but any help is appreciated.

private void BindSchool() { StringBuilder strQuery = new StringBuilder();

strQuery.Append("SELECT SCHOOLID, ");
strQuery.Append("SUBSTRING(NAME,1,1) AS 'BREAK', ");
strQuery.Append(" (NAME + ' (' + CITY + ', ' + STATE + ') ' ) AS SCHOOLNAME FROM SCHOOL WHERE (DELETED IS NULL OR DELETED <> 1)");

strQuery.Append("AND SCHOOLID NOT IN (1002,1003,1004,597,598,738,632)");

if (ddlState.SelectedValue != "") strQuery.Append("AND STATE = '" + Convert.ToString(ddlState.SelectedValue) + "'"); strQuery.Append(" ORDER BY SCHOOLNAME");