I have an existing application that is used to connect to a sql 2005 DB table to validate user names and passwords on a website. I need to add another validation to this code to test for a specific condition. The code makes the sql connection and verifies their password already and in that same row there is another column that has a numeric value. What I need to do is write a statement that says IF [column Name] = 20; execute this code etc. The existing code doesnt really give me anything to go on for how to verify a value against the field value. If it helps the DB name is "WEBSITEDB" and the table name is "CustomerMaster", the column name is "TestCode". If anyone can lend me some advice I would appreciate it greatly!