tag:blogger.com,1999:blog-497787815177352569.post3607533440229951793..comments2024-01-03T08:55:04.827-05:00Comments on SQL Anywhere: Why SQL Server Sucks: ISNULLBreck Carterhttp://www.blogger.com/profile/15975598564711761434noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-497787815177352569.post-51624516099621128062012-02-12T17:48:51.861-05:002012-02-12T17:48:51.861-05:00I remember something similar when using UNIONs on ...I remember something similar when using UNIONs on varchar literals, such as:<br /><br />select 'Hello' from MyTable<br />union<br />select 'Hello, World!' from MyTable<br />order by 1<br /><br />would return the columns based on the exact type of the first query block - here a [var]char(5) column - by that truncating the longer values from other query blocks...<br /><br />(No, not currently tested on MS SQL...)<br /><br />VolkerAnonymousnoreply@blogger.com