Hi I have a table service_desk_resolution_codes as below id | name
Rather than putting your prompt text in the table, get rid of it, and when you need to provide a drop-down for resolution code use the :prompt argument to have rails insert the prompt for you. I believe that will allow you to just put a "validates_presence_of :resolution_code" in the appropriate model & rails will "know" not to accept the prompt value.
So your call to collection_select might look like:
<%= f.collection_select(:resolution_code, ResolutionCode.find(:all), :id, :name, {:prompt => 'Please select a resolution'} ) %>
HTH,
-Roy