use the convert function select convert (varchar (11), datetimefield) + stringfield + convert (varchar (10) ,integerfield )
Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "Matthew Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 10:11 AM 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
