I have a Select statement.. which works in access.
SELECT smart_address.company & ' (' & smart_address.add_id & ' )' AS company1,
smart_address.*
but.. when the database into SQL 2005... it does not work.
[Macromedia][SQLServer JDBC Driver][SQLServer]The data types nvarchar and
varchar are incompatible in the boolean AND operator.
So... how can I combine 2 columns ?
I had tried to change from
& ' (' & into + '(' + but does not work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2978
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
