Dear all THe following works with Access but not SQL server
SELECT x, y, 'mapx=' & x & '&mapy=' & y AS pos FROM etc etc I have tried various changes eg altering & to + makes no difference; I am sure it is an easy fix but SQL server is still a bit of a mystery to me.... thanks in advance.. -- Regards; Richard Meredith-Hardy ------------------------------------------------------------- [EMAIL PROTECTED] ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

