I have problems retrieving the right data from my database fields.
I have two colums: Pref_First_Name and First_Name
If someone has a preferred first name I want it displayed in the browser, but if they don't have a preferred first name I want their first name displayed. I was trying something like this but it's not working:
<%if Pref_First_Name = "" then%><%=rs("First_Name"%><%else%>
Can anyone please help?