Thanks. This works. I am using SQL7 and '&' didn't work with it either.
By the way, do you know of any good resource on SQL statement online. It
would be nice to have a quick reference on those functions that I can use to
see the possibilities.
Thanks again.
> You can convert them, but this tends to trim;
> select convert(varchar(4096),text1)+convert(varchar(4096),text2) as text3
> from table1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
