all... this worked perfectly. select cast (versionMajor as varchar) + '.' + cast (versionMinor as varchar) + '.' + cast (versionRev as varchar) as softwareVersion from usersTable
:THANKS: tw On 10/4/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > select versionMajor + '.' + versionMinor + '.' + versionRev as > softwareVersion from usersTable > > im gettin an error? > > > Have you tried it with the other common concatenation operator, the ampersand > (&)? > > select versionMajor & '.' & versionMinor & '.' & versionRev > > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > --------- > | 1 | | > --------- Binary Soduko > | | | > --------- > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:216758 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5