Right, I have a simple query:
SELECT activityID, ActivityListName
WHERE dbo.custom_activity.ActivityName IS NOT NULL
ORDER BY ActivityListName ASC
The query is used to populate a drop-down list - activityID is the value returned from list to d/b and ActivityListName is the value displayed in drop-down list.
What I want to do is display an extra option (ie. blank) at the top of the drop-down list so that if no option is selected it returns a NULL value to d/b. At the moment the first entry is selected by default - which means an activityID is always returned to the d/b. This has to be done as part of SQL query as I don't control the drop-down lists.
Is this possible?
Thanks for any help.