Havnt tried this, but it might be possible to use CStr()... i.e. CStr(integerfield) as sFoo
Or maybe the Cast(integerfield as varchar) altho Im not sure that will work HTH -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 15:12 To: CF-Talk Subject: conversion of Access datatypes in the query Hi everyone - I need to be able to convert both a datetime field and an integer field to strings in a query (for concatenation with a string field) but I can't remember how to do it. Select datetimefield + stringfield + integerfield as stringtype from table Any help? Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
