Hey All,

I have a query that i have been having trouble with for some weeks and i am desperate to get working.

What i want to do is construct a statement from the values i pull from the database.

for example, i have 2 rows in the database, one field, called dbValue that has the values "Value 1" and "Value 2"

I want to pull the values from the database and construct an if statement like the following

if testing = Value 1 OR Value 2 then
else
end if

Could someone please help me out, the values have to be pulled from the database as they will be dynamic.

Pleaseeeeeeee Helppppppppp

Anyone?

I think you are new to sql query/asp. it will more better that you visit this site
http://www.w3schools.com

In this type of query u should use case.

Select (case testing when 'Value1' then 'somecode' else 'anothercode' end) as Result
From Table

Try this.