Anyone got an idea on how to help with this?
~*~*~*~*~*~*~
Shay Bella Holmes
~*~*~*~*~*~*~
On Thu, Aug 25, 2011 at 10:43 AM, Shay Holmes <shaybellaholmes@gmail.com>wrote:
> Working with Access 2010 & SQL Server 2008 has given me 2 questions ...
>
> 1) Why would Access show a non printable character that SSMS does not show?
> 2) How can I write a query (in T-SQL if not ANSI 92 SQL) that returns only
> non zero length & printable characters? I cannot change anything to do with
> SQL Server; I can only read from the tables.
>
> I tested my pass through queries in SSMS and it all looks fine, but when I
> display one of them in Access I'm seeing a non-printable character (a tab
> character) in the last column of a SELECT * FROM [table] pass through (query
> is for data techs to be able to diagnose bad data problems).
>
> The tables (on MSSQL) are populated via a bulk insert procedure that
> converts nulls to zero length strings. I'm supposed to be creating a related
> query that shows the frequency of certain columns containing data, and I'm
> told that the non printable character isn't hurting anything else and won't
> be fixed any time soon.
>
> Any help would be most appreciated.
>
> ~*~*~*~*~*~*~
> Shay Bella Holmes
> ~*~*~*~*~*~*~
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar