>Which field is Text datatype? If you're using SQL 2005 and up, cast TEXT field to varchar(max).

Url2 was Text datatype. I have adjusted and it works.

>Also, IMHO, it doesn't make much sense to have char(74) field. I would use varchar(74) instead.

Why would that be?

>Finally, if you want to get rid of the error, use UNION ALL instead of UNION.

When I use UNION ALL, it worked even before I changed the Text. What does UNION ALL exactly?