//Help converting these sql statements to C# (Also, sorry for the formatting) // #1 DECLARE NUM_OF_ITEMS CHARACTER; IF NUM_OF_ITEMS IS NOT NULL THEN IF NUM_OF_ITEMS > 100 THEN SET NUM_OF_ITEMS = '100'; END IF; END IF; //This is what I have so far... public string (string numOfItems) { if (numOfItems!= null) { if (numOfItems > 100) { numOfItems == "100"; } } } // #2........... DECLARE ID CHARACTER; DECLARE result CHARACTER IF ((ID IS NOT NULL) AND (ID <> '')) THEN DECLARE TEMP_ID INTEGER; SET TEMP_ID = CAST(ID AS INTEGER); IF ((TEMP_ID >= 1) AND (TEMP_ID < 25) AND (LENGTH(ID) < 5)) THEN SET result = result || ID; // This is what I have so far but not sure if im going in the correct direction... public string(string ID){ StringBuilder result = new StringBuilder(); if (!string.IsNullOrEmpty(ID)) { int TEMP_ID = Int32.TryParse(ID, out TEMP_ID); if ((TEMP_ID >= 1) && (TEMP_ID < 25) && (ID.Length < 5)) { result.Append(ID); } }