Hi I have a table with a column which is defined as a varchar that contains asterisks. If I query that column I get the expected results,
select col from tableA
However, if I select the same column using a query with a join condition I get the following output:
Select col from tableA A
left join tableB B
on a.key = b.key
In fact I get the same output if I include a second column in the first query, e.g
I'm running against a Sql2005 SP3 database.
Anyone got any ideas what is happening here or how to ensure I get the actual varchar value?