I don't think it matters because it will convert a number to a string. If you use cfqueryparam for the variable in your query, then that will ensure a proper conversion.
Eric /*-----Original Message----- /*From: erik tom [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, March 26, 2008 11:24 AM /*To: CF-Talk /*Subject: turn integer list into list of characters /* /*I have a query that returns the EmployeeiD, on the other table i have /*column employeeId which is varchar datatype. so my question is how can I /*convert integer list into char list so it looks like this /* /*<cfste list="'1233','12333','3333333' " and so on /* /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4