Okay, so I have some strings in a SQL db. I can display these just fine, using

objRSParks("ParkLink")

or by assigning this to a variable and the calling the variable, like so:

varDisplayPark = objRSParks("ParkLink")
Response.Write varDisplayPark

What I can't figure out is how to do comparisons with the variables. When I try this, it doesn't work:

If varDisplayPark = "central Park" Then
Response.Write "This is central park"
End If

I've tried changing the datatypes in the SQL database itself....I've tried text, varchar, char....

Is this a datatype problem, or something else?

Thanks,
WebGrrl

No, all those SQL data types translate to asp strings. Use whichever is most appropriate for your data ... probably varchar.

In ASP, your comparisons are case sensitive. Try something more like:

If lCase(Trim(objRSParks("ParkLink"))) = "central park" Then ...

Awesome, that worked beautifully. You rock...

Thanks,
WebGrrl