Query: <cfquery name="qname" datasource="games"> select distinct name from score </cfquery> OUTPUT: First Name: <cfselect name="selectname" query="qname" value="name" display="name" > </cfselect> Question: 1) Can I just display part of the name eg left(name,4) from the above CFSELECT ? 2) If I have another query, can I merge the 2 queries and display them in one CFSELECT ? appreciate any help SK ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
