This content has been marked as final. Show 4 replies
select last_name+', '+first_name AS uname
seems to work ok
couldn't even get || ', ' || to work...? using msSQL2000
The bars "||" work fine in Oracle for concatenating two fields together in the SQL. The problem I am having is in displaying the field that has a comma in the data in the CFSELECT.
My suggestion is to not store the user's name in your activiities table. Store the user_id, instead. Then you can use the user_id field, which is hopefully numeric, in your cfselect and you won't have any problems with commas.
use tilde "~" or something weird as deliminator in query
replace in select -option... don't know if will work in cfselect because the variable is not ##'ed